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 2005/05/26 10:59:45 appldev noship $ */
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 781: AHL_DEBUG_PUB.enable_debug;

777: -- Standard Start of API savepoint
778: SAVEPOINT create_space_assignment;
779: -- Check if API is called in debug mode. If yes, enable debug.
780: IF G_DEBUG='Y' THEN
781: AHL_DEBUG_PUB.enable_debug;
782: END IF;
783: -- Debug info.
784: IF G_DEBUG='Y' THEN
785: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');

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

781: AHL_DEBUG_PUB.enable_debug;
782: END IF;
783: -- Debug info.
784: IF G_DEBUG='Y' THEN
785: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');
786: END IF;
787: -- Standard call to check for call compatibility.
788: IF FND_API.to_boolean(p_init_msg_list)
789: THEN

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

799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801: --------------------Value OR ID conversion---------------------------
802: IF G_DEBUG='Y' THEN
803: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
804: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
805: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
806: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
807: END IF;

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

800: END IF;
801: --------------------Value OR ID conversion---------------------------
802: IF G_DEBUG='Y' THEN
803: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
804: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
805: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
806: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
807: END IF;
808: --

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

801: --------------------Value OR ID conversion---------------------------
802: IF G_DEBUG='Y' THEN
803: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
804: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
805: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
806: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
807: END IF;
808: --
809: IF p_reschedule_flag = 'Y' THEN

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

802: IF G_DEBUG='Y' THEN
803: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
804: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
805: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
806: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
807: END IF;
808: --
809: IF p_reschedule_flag = 'Y' THEN
810: --Check is required during rescheduling

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

810: --Check is required during rescheduling
811: IF (p_x_space_assign_rec.visit_id IS NOT NULL AND
812: p_x_space_assign_rec.visit_id <> FND_API.G_MISS_NUM ) THEN
813: --
814: AHL_DEBUG_PUB.debug( 'inside schedule flag:'||p_x_space_assign_rec.space_name);
815: --
816: DELETE FROM AHL_SPACE_ASSIGNMENTS
817: WHERE visit_id = p_x_space_assign_rec.visit_id;
818: --

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

819: END IF;
820: --
821: END IF; --Reschedule flag
822:
823: AHL_DEBUG_PUB.debug( 'number of records space_id'||p_x_space_assign_rec.space_name);
824:
825: -- Convert Space name to space id
826: IF (p_x_space_assign_rec.space_name IS NOT NULL AND
827: p_x_space_assign_rec.space_name <> FND_API.G_MISS_CHAR ) OR

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

1048: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1049: RAISE Fnd_Api.G_EXC_ERROR;
1050: END IF;
1051:
1052: Ahl_Debug_Pub.debug( 'Before insert state'||l_space_assignment_id);
1053:
1054: ----------------------------DML Operation---------------------------------
1055: --insert the record
1056: INSERT INTO AHL_SPACE_ASSIGNMENTS

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

1126: COMMIT;
1127: END IF;
1128: -- Debug info
1129: IF G_DEBUG='Y' THEN
1130: Ahl_Debug_Pub.debug( 'End of private api Create Space assignment','+SPANS+');
1131: -- Check if API is called in debug mode. If yes, disable debug.
1132: Ahl_Debug_Pub.disable_debug;
1133: END IF;
1134: EXCEPTION

Line 1132: Ahl_Debug_Pub.disable_debug;

1128: -- Debug info
1129: IF G_DEBUG='Y' THEN
1130: Ahl_Debug_Pub.debug( 'End of private api Create Space assignment','+SPANS+');
1131: -- Check if API is called in debug mode. If yes, disable debug.
1132: Ahl_Debug_Pub.disable_debug;
1133: END IF;
1134: EXCEPTION
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: ROLLBACK TO create_space_assignment;

Line 1143: AHL_DEBUG_PUB.log_app_messages (

1139: p_count => x_msg_count,
1140: p_data => x_msg_data);
1141: IF G_DEBUG='Y' THEN
1142:
1143: AHL_DEBUG_PUB.log_app_messages (
1144: x_msg_count, x_msg_data, 'ERROR' );
1145: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1146: -- Check if API is called in debug mode. If yes, disable debug.
1147: AHL_DEBUG_PUB.disable_debug;

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

1141: IF G_DEBUG='Y' THEN
1142:
1143: AHL_DEBUG_PUB.log_app_messages (
1144: x_msg_count, x_msg_data, 'ERROR' );
1145: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1146: -- Check if API is called in debug mode. If yes, disable debug.
1147: AHL_DEBUG_PUB.disable_debug;
1148: END IF;
1149: WHEN FND_API.G_EXC_ERROR THEN

Line 1147: AHL_DEBUG_PUB.disable_debug;

1143: AHL_DEBUG_PUB.log_app_messages (
1144: x_msg_count, x_msg_data, 'ERROR' );
1145: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1146: -- Check if API is called in debug mode. If yes, disable debug.
1147: AHL_DEBUG_PUB.disable_debug;
1148: END IF;
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: ROLLBACK TO create_space_assignment;
1151: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1157: AHL_DEBUG_PUB.log_app_messages (

1153: p_count => x_msg_count,
1154: p_data => X_msg_data);
1155: IF G_DEBUG='Y' THEN
1156: -- Debug info.
1157: AHL_DEBUG_PUB.log_app_messages (
1158: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1159: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1160: -- Check if API is called in debug mode. If yes, disable debug.
1161: AHL_DEBUG_PUB.disable_debug;

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

1155: IF G_DEBUG='Y' THEN
1156: -- Debug info.
1157: AHL_DEBUG_PUB.log_app_messages (
1158: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1159: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1160: -- Check if API is called in debug mode. If yes, disable debug.
1161: AHL_DEBUG_PUB.disable_debug;
1162: END IF;
1163: WHEN OTHERS THEN

Line 1161: AHL_DEBUG_PUB.disable_debug;

1157: AHL_DEBUG_PUB.log_app_messages (
1158: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1159: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1160: -- Check if API is called in debug mode. If yes, disable debug.
1161: AHL_DEBUG_PUB.disable_debug;
1162: END IF;
1163: WHEN OTHERS THEN
1164: ROLLBACK TO create_space_assignment;
1165: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1177: AHL_DEBUG_PUB.log_app_messages (

1173: p_count => x_msg_count,
1174: p_data => X_msg_data);
1175: IF G_DEBUG='Y' THEN
1176: -- Debug info.
1177: AHL_DEBUG_PUB.log_app_messages (
1178: x_msg_count, x_msg_data, 'SQL ERROR' );
1179: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1180: -- Check if API is called in debug mode. If yes, disable debug.
1181: AHL_DEBUG_PUB.disable_debug;

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

1175: IF G_DEBUG='Y' THEN
1176: -- Debug info.
1177: AHL_DEBUG_PUB.log_app_messages (
1178: x_msg_count, x_msg_data, 'SQL ERROR' );
1179: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1180: -- Check if API is called in debug mode. If yes, disable debug.
1181: AHL_DEBUG_PUB.disable_debug;
1182: END IF;
1183: END Create_Space_assignment;

Line 1181: AHL_DEBUG_PUB.disable_debug;

1177: AHL_DEBUG_PUB.log_app_messages (
1178: x_msg_count, x_msg_data, 'SQL ERROR' );
1179: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1180: -- Check if API is called in debug mode. If yes, disable debug.
1181: AHL_DEBUG_PUB.disable_debug;
1182: END IF;
1183: END Create_Space_assignment;
1184: --
1185: -- PROCEDURE

Line 1226: AHL_DEBUG_PUB.enable_debug;

1222: -- Standard Start of API savepoint
1223: SAVEPOINT update_space_assignment;
1224: -- Check if API is called in debug mode. If yes, enable debug.
1225: IF G_DEBUG='Y' THEN
1226: AHL_DEBUG_PUB.enable_debug;
1227: END IF;
1228: -- Debug info.
1229: IF G_DEBUG='Y' THEN
1230: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

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

1226: AHL_DEBUG_PUB.enable_debug;
1227: END IF;
1228: -- Debug info.
1229: IF G_DEBUG='Y' THEN
1230: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1231: END IF;
1232: -- Standard call to check for call compatibility.
1233: IF FND_API.to_boolean(p_init_msg_list)
1234: THEN

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

1355: COMMIT;
1356: END IF;
1357: -- Debug info
1358: IF G_DEBUG='Y' THEN
1359: Ahl_Debug_Pub.debug( 'End of private api Update Space assignment','+SPANT+');
1360: END IF;
1361: -- Check if API is called in debug mode. If yes, disable debug.
1362: IF G_DEBUG='Y' THEN
1363: Ahl_Debug_Pub.disable_debug;

Line 1363: Ahl_Debug_Pub.disable_debug;

1359: Ahl_Debug_Pub.debug( 'End of private api Update Space assignment','+SPANT+');
1360: END IF;
1361: -- Check if API is called in debug mode. If yes, disable debug.
1362: IF G_DEBUG='Y' THEN
1363: Ahl_Debug_Pub.disable_debug;
1364: END IF;
1365:
1366: EXCEPTION
1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1375: AHL_DEBUG_PUB.log_app_messages (

1371: p_count => x_msg_count,
1372: p_data => x_msg_data);
1373: IF G_DEBUG='Y' THEN
1374:
1375: AHL_DEBUG_PUB.log_app_messages (
1376: x_msg_count, x_msg_data, 'ERROR' );
1377: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1378: -- Check if API is called in debug mode. If yes, disable debug.
1379: AHL_DEBUG_PUB.disable_debug;

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

1373: IF G_DEBUG='Y' THEN
1374:
1375: AHL_DEBUG_PUB.log_app_messages (
1376: x_msg_count, x_msg_data, 'ERROR' );
1377: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1378: -- Check if API is called in debug mode. If yes, disable debug.
1379: AHL_DEBUG_PUB.disable_debug;
1380: END IF;
1381: WHEN FND_API.G_EXC_ERROR THEN

Line 1379: AHL_DEBUG_PUB.disable_debug;

1375: AHL_DEBUG_PUB.log_app_messages (
1376: x_msg_count, x_msg_data, 'ERROR' );
1377: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1378: -- Check if API is called in debug mode. If yes, disable debug.
1379: AHL_DEBUG_PUB.disable_debug;
1380: END IF;
1381: WHEN FND_API.G_EXC_ERROR THEN
1382: ROLLBACK TO update_space_assignment;
1383: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1389: AHL_DEBUG_PUB.log_app_messages (

1385: p_count => x_msg_count,
1386: p_data => X_msg_data);
1387: IF G_DEBUG='Y' THEN
1388: -- Debug info.
1389: AHL_DEBUG_PUB.log_app_messages (
1390: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1391: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1392: -- Check if API is called in debug mode. If yes, disable debug.
1393: AHL_DEBUG_PUB.disable_debug;

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

1387: IF G_DEBUG='Y' THEN
1388: -- Debug info.
1389: AHL_DEBUG_PUB.log_app_messages (
1390: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1391: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1392: -- Check if API is called in debug mode. If yes, disable debug.
1393: AHL_DEBUG_PUB.disable_debug;
1394: END IF;
1395: WHEN OTHERS THEN

Line 1393: AHL_DEBUG_PUB.disable_debug;

1389: AHL_DEBUG_PUB.log_app_messages (
1390: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1391: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1392: -- Check if API is called in debug mode. If yes, disable debug.
1393: AHL_DEBUG_PUB.disable_debug;
1394: END IF;
1395: WHEN OTHERS THEN
1396: ROLLBACK TO update_space_assignment;
1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1410: AHL_DEBUG_PUB.log_app_messages (

1406: p_data => X_msg_data);
1407:
1408: IF G_DEBUG='Y' THEN
1409: -- Debug info.
1410: AHL_DEBUG_PUB.log_app_messages (
1411: x_msg_count, x_msg_data, 'SQL ERROR' );
1412: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1413: -- Check if API is called in debug mode. If yes, disable debug.
1414: AHL_DEBUG_PUB.disable_debug;

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

1408: IF G_DEBUG='Y' THEN
1409: -- Debug info.
1410: AHL_DEBUG_PUB.log_app_messages (
1411: x_msg_count, x_msg_data, 'SQL ERROR' );
1412: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1413: -- Check if API is called in debug mode. If yes, disable debug.
1414: AHL_DEBUG_PUB.disable_debug;
1415: END IF;
1416: END Update_Space_Assignment;

Line 1414: AHL_DEBUG_PUB.disable_debug;

1410: AHL_DEBUG_PUB.log_app_messages (
1411: x_msg_count, x_msg_data, 'SQL ERROR' );
1412: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1413: -- Check if API is called in debug mode. If yes, disable debug.
1414: AHL_DEBUG_PUB.disable_debug;
1415: END IF;
1416: END Update_Space_Assignment;
1417: --
1418: -- PROCEDURE

Line 1499: AHL_DEBUG_PUB.enable_debug;

1495: -- Standard Start of API savepoint
1496: SAVEPOINT delete_space_assignment;
1497: -- Check if API is called in debug mode. If yes, enable debug.
1498: IF G_DEBUG='Y' THEN
1499: AHL_DEBUG_PUB.enable_debug;
1500: END IF;
1501: -- Debug info.
1502: IF G_DEBUG='Y' THEN
1503: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

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

1499: AHL_DEBUG_PUB.enable_debug;
1500: END IF;
1501: -- Debug info.
1502: IF G_DEBUG='Y' THEN
1503: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1504: END IF;
1505: -- Standard call to check for call compatibility.
1506: IF FND_API.to_boolean(p_init_msg_list)
1507: THEN

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

1520: IF (p_space_assign_rec.visit_id IS NOT NULL AND
1521: p_space_assign_rec.visit_id <> FND_API.G_MISS_NUM) THEN
1522: --
1523: IF G_DEBUG='Y' THEN
1524: AHL_DEBUG_PUB.debug( 'visit id'||p_space_assign_rec.visit_id);
1525: END IF;
1526:
1527: OPEN c_visit_spaces_cur(p_space_assign_rec.visit_id);
1528: LOOP

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

1530: EXIT WHEN c_visit_spaces_cur%NOTFOUND;
1531: IF l_visit_spaces_rec.space_id IS NOT NULL THEN
1532:
1533: IF G_DEBUG='Y' THEN
1534: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1535: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1536: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1537: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1538: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);

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

1531: IF l_visit_spaces_rec.space_id IS NOT NULL THEN
1532:
1533: IF G_DEBUG='Y' THEN
1534: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1535: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1536: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1537: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1538: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1539: END IF;

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

1532:
1533: IF G_DEBUG='Y' THEN
1534: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1535: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1536: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1537: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1538: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1539: END IF;
1540: --

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

1533: IF G_DEBUG='Y' THEN
1534: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1535: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1536: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1537: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1538: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1539: END IF;
1540: --
1541: IF (nvl(l_visit_spaces_rec.organization_id,-1) <> l_visit_spaces_rec.sporg_id

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

1534: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1535: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1536: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1537: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1538: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1539: END IF;
1540: --
1541: IF (nvl(l_visit_spaces_rec.organization_id,-1) <> l_visit_spaces_rec.sporg_id
1542: OR nvl(l_visit_spaces_rec.department_id,-1) <> l_visit_spaces_rec.spdept_id )

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

1580: RAISE FND_API.g_exc_error;
1581: END IF;
1582: CLOSE c_space_assign_cur;
1583: IF G_DEBUG='Y' THEN
1584: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);
1585: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);
1586: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);
1587: END IF;
1588: --Check for object version number

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

1581: END IF;
1582: CLOSE c_space_assign_cur;
1583: IF G_DEBUG='Y' THEN
1584: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);
1585: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);
1586: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);
1587: END IF;
1588: --Check for object version number
1589: IF l_object_version_number <> p_space_assign_rec.object_version_number

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

1582: CLOSE c_space_assign_cur;
1583: IF G_DEBUG='Y' THEN
1584: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);
1585: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);
1586: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);
1587: END IF;
1588: --Check for object version number
1589: IF l_object_version_number <> p_space_assign_rec.object_version_number
1590: THEN

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

1611: COMMIT;
1612: END IF;
1613: -- Debug info
1614: IF G_DEBUG='Y' THEN
1615: Ahl_Debug_Pub.debug( 'End of private api Delete Space Assignment','+SPANT+');
1616: END IF;
1617: -- Check if API is called in debug mode. If yes, disable debug.
1618: IF G_DEBUG='Y' THEN
1619: Ahl_Debug_Pub.disable_debug;

Line 1619: Ahl_Debug_Pub.disable_debug;

1615: Ahl_Debug_Pub.debug( 'End of private api Delete Space Assignment','+SPANT+');
1616: END IF;
1617: -- Check if API is called in debug mode. If yes, disable debug.
1618: IF G_DEBUG='Y' THEN
1619: Ahl_Debug_Pub.disable_debug;
1620: END IF;
1621:
1622: EXCEPTION
1623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1631: AHL_DEBUG_PUB.log_app_messages (

1627: p_count => x_msg_count,
1628: p_data => x_msg_data);
1629: IF G_DEBUG='Y' THEN
1630:
1631: AHL_DEBUG_PUB.log_app_messages (
1632: x_msg_count, x_msg_data, 'ERROR' );
1633: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1634: -- Check if API is called in debug mode. If yes, disable debug.
1635: AHL_DEBUG_PUB.disable_debug;

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

1629: IF G_DEBUG='Y' THEN
1630:
1631: AHL_DEBUG_PUB.log_app_messages (
1632: x_msg_count, x_msg_data, 'ERROR' );
1633: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1634: -- Check if API is called in debug mode. If yes, disable debug.
1635: AHL_DEBUG_PUB.disable_debug;
1636: END IF;
1637: WHEN FND_API.G_EXC_ERROR THEN

Line 1635: AHL_DEBUG_PUB.disable_debug;

1631: AHL_DEBUG_PUB.log_app_messages (
1632: x_msg_count, x_msg_data, 'ERROR' );
1633: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1634: -- Check if API is called in debug mode. If yes, disable debug.
1635: AHL_DEBUG_PUB.disable_debug;
1636: END IF;
1637: WHEN FND_API.G_EXC_ERROR THEN
1638: ROLLBACK TO delete_space_assignment;
1639: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1646: AHL_DEBUG_PUB.log_app_messages (

1642: p_data => X_msg_data);
1643: IF G_DEBUG='Y' THEN
1644:
1645: -- Debug info.
1646: AHL_DEBUG_PUB.log_app_messages (
1647: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1648: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1649: -- Check if API is called in debug mode. If yes, disable debug.
1650: AHL_DEBUG_PUB.disable_debug;

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

1644:
1645: -- Debug info.
1646: AHL_DEBUG_PUB.log_app_messages (
1647: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1648: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1649: -- Check if API is called in debug mode. If yes, disable debug.
1650: AHL_DEBUG_PUB.disable_debug;
1651: END IF;
1652: WHEN OTHERS THEN

Line 1650: AHL_DEBUG_PUB.disable_debug;

1646: AHL_DEBUG_PUB.log_app_messages (
1647: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1648: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1649: -- Check if API is called in debug mode. If yes, disable debug.
1650: AHL_DEBUG_PUB.disable_debug;
1651: END IF;
1652: WHEN OTHERS THEN
1653: ROLLBACK TO delete_space_assignment;
1654: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1667: AHL_DEBUG_PUB.log_app_messages (

1663: p_data => X_msg_data);
1664: IF G_DEBUG='Y' THEN
1665:
1666: -- Debug info.
1667: AHL_DEBUG_PUB.log_app_messages (
1668: x_msg_count, x_msg_data, 'SQL ERROR' );
1669: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1670: -- Check if API is called in debug mode. If yes, disable debug.
1671: AHL_DEBUG_PUB.disable_debug;

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

1665:
1666: -- Debug info.
1667: AHL_DEBUG_PUB.log_app_messages (
1668: x_msg_count, x_msg_data, 'SQL ERROR' );
1669: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1670: -- Check if API is called in debug mode. If yes, disable debug.
1671: AHL_DEBUG_PUB.disable_debug;
1672: END IF;
1673: END Delete_Space_Assignment;

Line 1671: AHL_DEBUG_PUB.disable_debug;

1667: AHL_DEBUG_PUB.log_app_messages (
1668: x_msg_count, x_msg_data, 'SQL ERROR' );
1669: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1670: -- Check if API is called in debug mode. If yes, disable debug.
1671: AHL_DEBUG_PUB.disable_debug;
1672: END IF;
1673: END Delete_Space_Assignment;
1674: --
1675: -- PROCEDURE

Line 1793: AHL_DEBUG_PUB.enable_debug;

1789: -- Standard Start of API savepoint
1790: SAVEPOINT schedule_visit;
1791: -- Check if API is called in debug mode. If yes, enable debug.
1792: IF G_DEBUG='Y' THEN
1793: AHL_DEBUG_PUB.enable_debug;
1794: END IF;
1795: -- Debug info.
1796: IF G_DEBUG='Y' THEN
1797: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

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

1793: AHL_DEBUG_PUB.enable_debug;
1794: END IF;
1795: -- Debug info.
1796: IF G_DEBUG='Y' THEN
1797: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
1798: END IF;
1799: -- Standard call to check for call compatibility.
1800: IF FND_API.to_boolean(p_init_msg_list)
1801: THEN

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

1817: p_x_schedule_visit_rec.dept_id := null;
1818: END IF;
1819:
1820: IF G_DEBUG='Y' THEN
1821: AHL_DEBUG_PUB.debug( 'planned end hour'||p_x_schedule_visit_rec.planned_end_hour);
1822: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
1823: END IF;
1824:
1825: IF G_DEBUG='Y' THEN

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

1818: END IF;
1819:
1820: IF G_DEBUG='Y' THEN
1821: AHL_DEBUG_PUB.debug( 'planned end hour'||p_x_schedule_visit_rec.planned_end_hour);
1822: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
1823: END IF;
1824:
1825: IF G_DEBUG='Y' THEN
1826: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.org_name);

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

1822: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
1823: END IF;
1824:
1825: IF G_DEBUG='Y' THEN
1826: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.org_name);
1827: END IF;
1828:
1829: -- moved this block of code up, to get acess to l_visit_id
1830: -- Convert Visit Number to visit id

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

1868: END IF;
1869: END IF;
1870:
1871: IF G_DEBUG='Y' THEN
1872: AHL_DEBUG_PUB.debug( 'dept name'||p_x_schedule_visit_rec.dept_name);
1873: END IF;
1874: --DEPT ID
1875: IF ( p_x_schedule_visit_rec.dept_name IS NULL OR
1876: p_x_schedule_visit_rec.dept_name = FND_API.G_MISS_CHAR) THEN

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

1892: END IF;
1893: --
1894:
1895: IF G_DEBUG='Y' THEN
1896: AHL_DEBUG_PUB.debug( 'space mean:'||p_x_schedule_visit_rec.space_category_mean);
1897: AHL_DEBUG_PUB.debug( 'space code:'||p_x_schedule_visit_rec.space_category_code);
1898: END IF;
1899:
1900: --For Space Category

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

1893: --
1894:
1895: IF G_DEBUG='Y' THEN
1896: AHL_DEBUG_PUB.debug( 'space mean:'||p_x_schedule_visit_rec.space_category_mean);
1897: AHL_DEBUG_PUB.debug( 'space code:'||p_x_schedule_visit_rec.space_category_code);
1898: END IF;
1899:
1900: --For Space Category
1901: IF p_x_schedule_visit_rec.space_category_mean IS NOT NULL AND

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

1924: END IF;
1925: END IF;
1926:
1927: IF G_DEBUG='Y' THEN
1928: AHL_DEBUG_PUB.debug( 'mean:'||p_x_schedule_visit_rec.visit_type_mean);
1929: AHL_DEBUG_PUB.debug( 'visit type code:'||p_x_schedule_visit_rec.visit_type_code);
1930: END IF;
1931:
1932: -- Visit type code

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

1925: END IF;
1926:
1927: IF G_DEBUG='Y' THEN
1928: AHL_DEBUG_PUB.debug( 'mean:'||p_x_schedule_visit_rec.visit_type_mean);
1929: AHL_DEBUG_PUB.debug( 'visit type code:'||p_x_schedule_visit_rec.visit_type_code);
1930: END IF;
1931:
1932: -- Visit type code
1933: IF p_x_schedule_visit_rec.visit_type_mean IS NOT NULL AND

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

1981: END IF;
1982: */
1983:
1984: IF G_DEBUG='Y' THEN
1985: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.dept_id);
1986: AHL_DEBUG_PUB.debug( 'visit type'||p_x_schedule_visit_rec.visit_type_code);
1987: END IF;
1988: --
1989: IF G_DEBUG='Y' THEN

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

1982: */
1983:
1984: IF G_DEBUG='Y' THEN
1985: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.dept_id);
1986: AHL_DEBUG_PUB.debug( 'visit type'||p_x_schedule_visit_rec.visit_type_code);
1987: END IF;
1988: --
1989: IF G_DEBUG='Y' THEN
1990: AHL_DEBUG_PUB.debug( 'schedule visits schedule_flag'||p_x_schedule_visit_rec.schedule_flag);

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

1986: AHL_DEBUG_PUB.debug( 'visit type'||p_x_schedule_visit_rec.visit_type_code);
1987: END IF;
1988: --
1989: IF G_DEBUG='Y' THEN
1990: AHL_DEBUG_PUB.debug( 'schedule visits schedule_flag'||p_x_schedule_visit_rec.schedule_flag);
1991: END IF;
1992:
1993: -- anraj: commented, issue number 144
1994: -- commented since space assigments are taken care of in the AHL_VWP_VISITS_PVT.Process_Visit

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

2077: END IF;
2078:
2079: --
2080: IF G_DEBUG='Y' THEN
2081: 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');
2082: AHL_DEBUG_PUB.debug( 'start hour'||p_x_schedule_visit_rec.start_hour);
2083: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2084: END IF;
2085:

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

2078:
2079: --
2080: IF G_DEBUG='Y' THEN
2081: 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');
2082: AHL_DEBUG_PUB.debug( 'start hour'||p_x_schedule_visit_rec.start_hour);
2083: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2084: END IF;
2085:
2086: --Check for visit scheduled or not

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

2079: --
2080: IF G_DEBUG='Y' THEN
2081: 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');
2082: AHL_DEBUG_PUB.debug( 'start hour'||p_x_schedule_visit_rec.start_hour);
2083: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2084: END IF;
2085:
2086: --Check for visit scheduled or not
2087: -- anraj: commented, issue number 144

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

2100: RAISE Fnd_Api.G_EXC_ERROR;
2101: END IF;
2102:
2103: IF G_DEBUG='Y' THEN
2104: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2105: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2106: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);

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

2101: END IF;
2102:
2103: IF G_DEBUG='Y' THEN
2104: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2105: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2106: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2109: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);

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

2102:
2103: IF G_DEBUG='Y' THEN
2104: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2105: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2106: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2109: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2110: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);

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

2103: IF G_DEBUG='Y' THEN
2104: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2105: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2106: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2109: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2110: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2111: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);

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

2104: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2105: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2106: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2109: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2110: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2111: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2112: END IF;

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

2105: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2106: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2109: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2110: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2111: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2112: END IF;
2113:

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

2106: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2109: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2110: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2111: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2112: END IF;
2113:
2114: l_Visit_tbl(i).VISIT_ID := l_visit_id;

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

2107: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2108: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2109: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2110: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2111: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2112: END IF;
2113:
2114: l_Visit_tbl(i).VISIT_ID := l_visit_id;
2115: l_Visit_tbl(i).VISIT_NUMBER := p_x_schedule_visit_rec.visit_number;

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

2180: trunc(p_x_schedule_visit_rec.start_date) <> l_start_date_time OR
2181: l_dummy IS NOT NULL ) THEN
2182:
2183: IF G_DEBUG='Y' THEN
2184: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2185: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2186: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2187: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2188: END IF;

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

2181: l_dummy IS NOT NULL ) THEN
2182:
2183: IF G_DEBUG='Y' THEN
2184: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2185: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2186: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2187: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2188: END IF;
2189:

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

2182:
2183: IF G_DEBUG='Y' THEN
2184: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2185: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2186: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2187: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2188: END IF;
2189:
2190: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

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

2183: IF G_DEBUG='Y' THEN
2184: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2185: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2186: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2187: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2188: END IF;
2189:
2190: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2191: fnd_log.string

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

2228: COMMIT;
2229: END IF;
2230: -- Debug info
2231: IF G_DEBUG='Y' THEN
2232: Ahl_Debug_Pub.debug( 'End of private api Schedule Visit','+SPANT+');
2233: END IF;
2234: -- Check if API is called in debug mode. If yes, disable debug.
2235: IF G_DEBUG='Y' THEN
2236: Ahl_Debug_Pub.disable_debug;

Line 2236: Ahl_Debug_Pub.disable_debug;

2232: Ahl_Debug_Pub.debug( 'End of private api Schedule Visit','+SPANT+');
2233: END IF;
2234: -- Check if API is called in debug mode. If yes, disable debug.
2235: IF G_DEBUG='Y' THEN
2236: Ahl_Debug_Pub.disable_debug;
2237: END IF;
2238: EXCEPTION
2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2240: ROLLBACK TO schedule_visit;

Line 2247: AHL_DEBUG_PUB.log_app_messages (

2243: p_count => x_msg_count,
2244: p_data => x_msg_data);
2245: IF G_DEBUG='Y' THEN
2246:
2247: AHL_DEBUG_PUB.log_app_messages (
2248: x_msg_count, x_msg_data, 'ERROR' );
2249: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2250: -- Check if API is called in debug mode. If yes, disable debug.
2251: AHL_DEBUG_PUB.disable_debug;

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

2245: IF G_DEBUG='Y' THEN
2246:
2247: AHL_DEBUG_PUB.log_app_messages (
2248: x_msg_count, x_msg_data, 'ERROR' );
2249: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2250: -- Check if API is called in debug mode. If yes, disable debug.
2251: AHL_DEBUG_PUB.disable_debug;
2252: END IF;
2253: WHEN FND_API.G_EXC_ERROR THEN

Line 2251: AHL_DEBUG_PUB.disable_debug;

2247: AHL_DEBUG_PUB.log_app_messages (
2248: x_msg_count, x_msg_data, 'ERROR' );
2249: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2250: -- Check if API is called in debug mode. If yes, disable debug.
2251: AHL_DEBUG_PUB.disable_debug;
2252: END IF;
2253: WHEN FND_API.G_EXC_ERROR THEN
2254: ROLLBACK TO schedule_visit;
2255: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2262: AHL_DEBUG_PUB.log_app_messages (

2258: p_data => X_msg_data);
2259: IF G_DEBUG='Y' THEN
2260:
2261: -- Debug info.
2262: AHL_DEBUG_PUB.log_app_messages (
2263: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2264: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2265: -- Check if API is called in debug mode. If yes, disable debug.
2266: AHL_DEBUG_PUB.disable_debug;

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

2260:
2261: -- Debug info.
2262: AHL_DEBUG_PUB.log_app_messages (
2263: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2264: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2265: -- Check if API is called in debug mode. If yes, disable debug.
2266: AHL_DEBUG_PUB.disable_debug;
2267: END IF;
2268: WHEN OTHERS THEN

Line 2266: AHL_DEBUG_PUB.disable_debug;

2262: AHL_DEBUG_PUB.log_app_messages (
2263: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2264: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2265: -- Check if API is called in debug mode. If yes, disable debug.
2266: AHL_DEBUG_PUB.disable_debug;
2267: END IF;
2268: WHEN OTHERS THEN
2269: ROLLBACK TO schedule_visit;
2270: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2283: AHL_DEBUG_PUB.log_app_messages (

2279: p_data => X_msg_data);
2280: IF G_DEBUG='Y' THEN
2281:
2282: -- Debug info.
2283: AHL_DEBUG_PUB.log_app_messages (
2284: x_msg_count, x_msg_data, 'SQL ERROR' );
2285: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2286: -- Check if API is called in debug mode. If yes, disable debug.
2287: AHL_DEBUG_PUB.disable_debug;

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

2281:
2282: -- Debug info.
2283: AHL_DEBUG_PUB.log_app_messages (
2284: x_msg_count, x_msg_data, 'SQL ERROR' );
2285: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2286: -- Check if API is called in debug mode. If yes, disable debug.
2287: AHL_DEBUG_PUB.disable_debug;
2288:
2289: END IF;

Line 2287: AHL_DEBUG_PUB.disable_debug;

2283: AHL_DEBUG_PUB.log_app_messages (
2284: x_msg_count, x_msg_data, 'SQL ERROR' );
2285: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2286: -- Check if API is called in debug mode. If yes, disable debug.
2287: AHL_DEBUG_PUB.disable_debug;
2288:
2289: END IF;
2290: END Schedule_Visit;
2291: --

Line 2381: AHL_DEBUG_PUB.enable_debug;

2377: -- Standard Start of API savepoint
2378: SAVEPOINT unschedule_visit;
2379: -- Check if API is called in debug mode. If yes, enable debug.
2380: IF G_DEBUG='Y' THEN
2381: AHL_DEBUG_PUB.enable_debug;
2382: END IF;
2383: -- Debug info.
2384: IF G_DEBUG='Y' THEN
2385: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

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

2381: AHL_DEBUG_PUB.enable_debug;
2382: END IF;
2383: -- Debug info.
2384: IF G_DEBUG='Y' THEN
2385: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2386: END IF;
2387: -- Standard call to check for call compatibility.
2388: IF FND_API.to_boolean(p_init_msg_list)
2389: THEN

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

2589: COMMIT;
2590: END IF;
2591: -- Debug info
2592: IF G_DEBUG='Y' THEN
2593: Ahl_Debug_Pub.debug( 'End of private api Unschedule Visit','+SPANT+');
2594: -- Check if API is called in debug mode. If yes, disable debug.
2595: Ahl_Debug_Pub.disable_debug;
2596: END IF;
2597: EXCEPTION

Line 2595: Ahl_Debug_Pub.disable_debug;

2591: -- Debug info
2592: IF G_DEBUG='Y' THEN
2593: Ahl_Debug_Pub.debug( 'End of private api Unschedule Visit','+SPANT+');
2594: -- Check if API is called in debug mode. If yes, disable debug.
2595: Ahl_Debug_Pub.disable_debug;
2596: END IF;
2597: EXCEPTION
2598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2599: ROLLBACK TO unschedule_visit;

Line 2606: AHL_DEBUG_PUB.log_app_messages (

2602: p_count => x_msg_count,
2603: p_data => x_msg_data);
2604: IF G_DEBUG='Y' THEN
2605:
2606: AHL_DEBUG_PUB.log_app_messages (
2607: x_msg_count, x_msg_data, 'ERROR' );
2608: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2609: -- Check if API is called in debug mode. If yes, disable debug.
2610: AHL_DEBUG_PUB.disable_debug;

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

2604: IF G_DEBUG='Y' THEN
2605:
2606: AHL_DEBUG_PUB.log_app_messages (
2607: x_msg_count, x_msg_data, 'ERROR' );
2608: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2609: -- Check if API is called in debug mode. If yes, disable debug.
2610: AHL_DEBUG_PUB.disable_debug;
2611: END IF;
2612: WHEN FND_API.G_EXC_ERROR THEN

Line 2610: AHL_DEBUG_PUB.disable_debug;

2606: AHL_DEBUG_PUB.log_app_messages (
2607: x_msg_count, x_msg_data, 'ERROR' );
2608: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2609: -- Check if API is called in debug mode. If yes, disable debug.
2610: AHL_DEBUG_PUB.disable_debug;
2611: END IF;
2612: WHEN FND_API.G_EXC_ERROR THEN
2613: ROLLBACK TO unschedule_visit;
2614: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2621: AHL_DEBUG_PUB.log_app_messages (

2617: p_data => X_msg_data);
2618: IF G_DEBUG='Y' THEN
2619:
2620: -- Debug info.
2621: AHL_DEBUG_PUB.log_app_messages (
2622: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2623: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
2624: -- Check if API is called in debug mode. If yes, disable debug.
2625: AHL_DEBUG_PUB.disable_debug;

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

2619:
2620: -- Debug info.
2621: AHL_DEBUG_PUB.log_app_messages (
2622: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2623: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
2624: -- Check if API is called in debug mode. If yes, disable debug.
2625: AHL_DEBUG_PUB.disable_debug;
2626: END IF;
2627: WHEN OTHERS THEN

Line 2625: AHL_DEBUG_PUB.disable_debug;

2621: AHL_DEBUG_PUB.log_app_messages (
2622: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2623: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
2624: -- Check if API is called in debug mode. If yes, disable debug.
2625: AHL_DEBUG_PUB.disable_debug;
2626: END IF;
2627: WHEN OTHERS THEN
2628: ROLLBACK TO unschedule_visit;
2629: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2642: AHL_DEBUG_PUB.log_app_messages (

2638: p_data => X_msg_data);
2639: IF G_DEBUG='Y' THEN
2640:
2641: -- Debug info.
2642: AHL_DEBUG_PUB.log_app_messages (
2643: x_msg_count, x_msg_data, 'SQL ERROR' );
2644: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2645: -- Check if API is called in debug mode. If yes, disable debug.
2646: AHL_DEBUG_PUB.disable_debug;

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

2640:
2641: -- Debug info.
2642: AHL_DEBUG_PUB.log_app_messages (
2643: x_msg_count, x_msg_data, 'SQL ERROR' );
2644: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2645: -- Check if API is called in debug mode. If yes, disable debug.
2646: AHL_DEBUG_PUB.disable_debug;
2647: END IF;
2648: END Unschedule_Visit;

Line 2646: AHL_DEBUG_PUB.disable_debug;

2642: AHL_DEBUG_PUB.log_app_messages (
2643: x_msg_count, x_msg_data, 'SQL ERROR' );
2644: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2645: -- Check if API is called in debug mode. If yes, disable debug.
2646: AHL_DEBUG_PUB.disable_debug;
2647: END IF;
2648: END Unschedule_Visit;
2649:
2650: END AHL_LTP_SPACE_ASSIGN_PVT;