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_CAPB_PVT dependencies on AHL_DEBUG_PUB

Line 339: AHL_DEBUG_PUB.debug( 'DUMMY'||l_dummy);

335: OPEN check_dup_name(p_space_rec.space_name,l_space_rec.bom_department_id);
336: FETCH check_dup_name INTO l_dummy;
337: CLOSE check_dup_name;
338: IF G_DEBUG='Y' THEN
339: AHL_DEBUG_PUB.debug( 'DUMMY'||l_dummy);
340: END IF;
341: IF l_dummy IS NOT NULL THEN
342: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NAME_EXISTS');
343: Fnd_Msg_Pub.ADD;

Line 814: AHL_DEBUG_PUB.enable_debug;

810: -- Standard Start of API savepoint
811: SAVEPOINT create_space;
812: -- Check if API is called in debug mode. If yes, enable debug.
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.enable_debug;
815: END IF;
816: -- Debug info.
817: IF G_DEBUG='Y' THEN
818: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Create Space ','+SPCBL+');

Line 818: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Create Space ','+SPCBL+');

814: AHL_DEBUG_PUB.enable_debug;
815: END IF;
816: -- Debug info.
817: IF G_DEBUG='Y' THEN
818: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Create Space ','+SPCBL+');
819: END IF;
820: -- Standard call to check for call compatibility.
821: IF FND_API.to_boolean(p_init_msg_list)
822: THEN

Line 1163: Ahl_Debug_Pub.debug( 'End of private api Create Space ','+SPCBL+');

1159: COMMIT;
1160: END IF;
1161: -- Debug info
1162: IF G_DEBUG='Y' THEN
1163: Ahl_Debug_Pub.debug( 'End of private api Create Space ','+SPCBL+');
1164: -- Check if API is called in debug mode. If yes, disable debug.
1165: Ahl_Debug_Pub.disable_debug;
1166: END IF;
1167: EXCEPTION

Line 1165: Ahl_Debug_Pub.disable_debug;

1161: -- Debug info
1162: IF G_DEBUG='Y' THEN
1163: Ahl_Debug_Pub.debug( 'End of private api Create Space ','+SPCBL+');
1164: -- Check if API is called in debug mode. If yes, disable debug.
1165: Ahl_Debug_Pub.disable_debug;
1166: END IF;
1167: EXCEPTION
1168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1169: ROLLBACK TO create_space;

Line 1175: AHL_DEBUG_PUB.log_app_messages (

1171: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,
1173: p_data => x_msg_data);
1174: IF G_DEBUG='Y' THEN
1175: AHL_DEBUG_PUB.log_app_messages (
1176: x_msg_count, x_msg_data, 'ERROR' );
1177: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space ','+SPCBL+');
1178: -- Check if API is called in debug mode. If yes, disable debug.
1179: AHL_DEBUG_PUB.disable_debug;

Line 1177: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space ','+SPCBL+');

1173: p_data => x_msg_data);
1174: IF G_DEBUG='Y' THEN
1175: AHL_DEBUG_PUB.log_app_messages (
1176: x_msg_count, x_msg_data, 'ERROR' );
1177: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space ','+SPCBL+');
1178: -- Check if API is called in debug mode. If yes, disable debug.
1179: AHL_DEBUG_PUB.disable_debug;
1180: END IF;
1181: WHEN FND_API.G_EXC_ERROR THEN

Line 1179: AHL_DEBUG_PUB.disable_debug;

1175: AHL_DEBUG_PUB.log_app_messages (
1176: x_msg_count, x_msg_data, 'ERROR' );
1177: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space ','+SPCBL+');
1178: -- Check if API is called in debug mode. If yes, disable debug.
1179: AHL_DEBUG_PUB.disable_debug;
1180: END IF;
1181: WHEN FND_API.G_EXC_ERROR THEN
1182: ROLLBACK TO create_space;
1183: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1189: AHL_DEBUG_PUB.log_app_messages (

1185: p_count => x_msg_count,
1186: p_data => X_msg_data);
1187: IF G_DEBUG='Y' THEN
1188: -- Debug info.
1189: AHL_DEBUG_PUB.log_app_messages (
1190: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1191: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');
1192: -- Check if API is called in debug mode. If yes, disable debug.
1193: AHL_DEBUG_PUB.disable_debug;

Line 1191: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');

1187: IF G_DEBUG='Y' THEN
1188: -- Debug info.
1189: AHL_DEBUG_PUB.log_app_messages (
1190: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1191: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');
1192: -- Check if API is called in debug mode. If yes, disable debug.
1193: AHL_DEBUG_PUB.disable_debug;
1194: END IF;
1195: WHEN OTHERS THEN

Line 1193: AHL_DEBUG_PUB.disable_debug;

1189: AHL_DEBUG_PUB.log_app_messages (
1190: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1191: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');
1192: -- Check if API is called in debug mode. If yes, disable debug.
1193: AHL_DEBUG_PUB.disable_debug;
1194: END IF;
1195: WHEN OTHERS THEN
1196: ROLLBACK TO create_space;
1197: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1209: AHL_DEBUG_PUB.log_app_messages (

1205: p_count => x_msg_count,
1206: p_data => X_msg_data);
1207: IF G_DEBUG='Y' THEN
1208: -- Debug info.
1209: AHL_DEBUG_PUB.log_app_messages (
1210: x_msg_count, x_msg_data, 'SQL ERROR' );
1211: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');
1212: -- Check if API is called in debug mode. If yes, disable debug.
1213: AHL_DEBUG_PUB.disable_debug;

Line 1211: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');

1207: IF G_DEBUG='Y' THEN
1208: -- Debug info.
1209: AHL_DEBUG_PUB.log_app_messages (
1210: x_msg_count, x_msg_data, 'SQL ERROR' );
1211: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');
1212: -- Check if API is called in debug mode. If yes, disable debug.
1213: AHL_DEBUG_PUB.disable_debug;
1214: END IF;
1215:

Line 1213: AHL_DEBUG_PUB.disable_debug;

1209: AHL_DEBUG_PUB.log_app_messages (
1210: x_msg_count, x_msg_data, 'SQL ERROR' );
1211: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space','+SPCBL+');
1212: -- Check if API is called in debug mode. If yes, disable debug.
1213: AHL_DEBUG_PUB.disable_debug;
1214: END IF;
1215:
1216: END Create_Space;
1217:

Line 1273: AHL_DEBUG_PUB.enable_debug;

1269: -- Standard Start of API savepoint
1270: SAVEPOINT update_space;
1271: -- Check if API is called in debug mode. If yes, enable debug.
1272: IF G_DEBUG='Y' THEN
1273: AHL_DEBUG_PUB.enable_debug;
1274: END IF;
1275: -- Debug info.
1276: IF G_DEBUG='Y' THEN
1277: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');

Line 1277: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');

1273: AHL_DEBUG_PUB.enable_debug;
1274: END IF;
1275: -- Debug info.
1276: IF G_DEBUG='Y' THEN
1277: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');
1278: END IF;
1279: -- Standard call to check for call compatibility.
1280: IF FND_API.to_boolean(p_init_msg_list)
1281: THEN

Line 1296: Ahl_Debug_Pub.debug( 'space id'||p_space_rec.space_id);

1292: END IF;
1293:
1294: --------------------Value OR ID conversion---------------------------
1295: IF G_DEBUG='Y' THEN
1296: Ahl_Debug_Pub.debug( 'space id'||p_space_rec.space_id);
1297: Ahl_Debug_Pub.debug( 'space id'||p_space_rec.space_name);
1298: END IF;
1299: --Assign to local variable
1300: Assign_Space_Rec (

Line 1297: Ahl_Debug_Pub.debug( 'space id'||p_space_rec.space_name);

1293:
1294: --------------------Value OR ID conversion---------------------------
1295: IF G_DEBUG='Y' THEN
1296: Ahl_Debug_Pub.debug( 'space id'||p_space_rec.space_id);
1297: Ahl_Debug_Pub.debug( 'space id'||p_space_rec.space_name);
1298: END IF;
1299: --Assign to local variable
1300: Assign_Space_Rec (
1301: p_space_rec => p_space_rec,

Line 1423: Ahl_Debug_Pub.debug( 'before update space id'||p_space_rec.space_id);

1419: RAISE Fnd_Api.G_EXC_ERROR;
1420: END IF;
1421: --
1422: IF G_DEBUG='Y' THEN
1423: Ahl_Debug_Pub.debug( 'before update space id'||p_space_rec.space_id);
1424: END IF;
1425: ----------------------------DML Operation---------------------------------
1426: --Call table handler generated package to update a record
1427: AHL_SPACES_PKG.UPDATE_ROW

Line 1473: Ahl_Debug_Pub.debug( 'End of private api Update Space ','+SPCBL+');

1469: COMMIT;
1470: END IF;
1471: -- Debug info
1472: IF G_DEBUG='Y' THEN
1473: Ahl_Debug_Pub.debug( 'End of private api Update Space ','+SPCBL+');
1474: -- Check if API is called in debug mode. If yes, disable debug.
1475: Ahl_Debug_Pub.disable_debug;
1476: END IF;
1477: EXCEPTION

Line 1475: Ahl_Debug_Pub.disable_debug;

1471: -- Debug info
1472: IF G_DEBUG='Y' THEN
1473: Ahl_Debug_Pub.debug( 'End of private api Update Space ','+SPCBL+');
1474: -- Check if API is called in debug mode. If yes, disable debug.
1475: Ahl_Debug_Pub.disable_debug;
1476: END IF;
1477: EXCEPTION
1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1479: ROLLBACK TO update_space;

Line 1485: AHL_DEBUG_PUB.log_app_messages (

1481: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1482: p_count => x_msg_count,
1483: p_data => x_msg_data);
1484: IF G_DEBUG='Y' THEN
1485: AHL_DEBUG_PUB.log_app_messages (
1486: x_msg_count, x_msg_data, 'ERROR' );
1487: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');
1488: -- Check if API is called in debug mode. If yes, disable debug.
1489: AHL_DEBUG_PUB.disable_debug;

Line 1487: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');

1483: p_data => x_msg_data);
1484: IF G_DEBUG='Y' THEN
1485: AHL_DEBUG_PUB.log_app_messages (
1486: x_msg_count, x_msg_data, 'ERROR' );
1487: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');
1488: -- Check if API is called in debug mode. If yes, disable debug.
1489: AHL_DEBUG_PUB.disable_debug;
1490: END IF;
1491: WHEN FND_API.G_EXC_ERROR THEN

Line 1489: AHL_DEBUG_PUB.disable_debug;

1485: AHL_DEBUG_PUB.log_app_messages (
1486: x_msg_count, x_msg_data, 'ERROR' );
1487: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');
1488: -- Check if API is called in debug mode. If yes, disable debug.
1489: AHL_DEBUG_PUB.disable_debug;
1490: END IF;
1491: WHEN FND_API.G_EXC_ERROR THEN
1492: ROLLBACK TO update_space;
1493: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1499: AHL_DEBUG_PUB.log_app_messages (

1495: p_count => x_msg_count,
1496: p_data => X_msg_data);
1497: -- Debug info.
1498: IF G_DEBUG='Y' THEN
1499: AHL_DEBUG_PUB.log_app_messages (
1500: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1501: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');
1502: -- Check if API is called in debug mode. If yes, disable debug.
1503: AHL_DEBUG_PUB.disable_debug;

Line 1501: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');

1497: -- Debug info.
1498: IF G_DEBUG='Y' THEN
1499: AHL_DEBUG_PUB.log_app_messages (
1500: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1501: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');
1502: -- Check if API is called in debug mode. If yes, disable debug.
1503: AHL_DEBUG_PUB.disable_debug;
1504: END IF;
1505: WHEN OTHERS THEN

Line 1503: AHL_DEBUG_PUB.disable_debug;

1499: AHL_DEBUG_PUB.log_app_messages (
1500: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1501: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space ','+SPCBL+');
1502: -- Check if API is called in debug mode. If yes, disable debug.
1503: AHL_DEBUG_PUB.disable_debug;
1504: END IF;
1505: WHEN OTHERS THEN
1506: ROLLBACK TO update_space;
1507: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1520: AHL_DEBUG_PUB.log_app_messages (

1516: p_data => X_msg_data);
1517:
1518: -- Debug info.
1519: IF G_DEBUG='Y' THEN
1520: AHL_DEBUG_PUB.log_app_messages (
1521: x_msg_count, x_msg_data, 'SQL ERROR' );
1522: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Update Space ','+SPCBL+');
1523: -- Check if API is called in debug mode. If yes, disable debug.
1524: AHL_DEBUG_PUB.disable_debug;

Line 1522: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Update Space ','+SPCBL+');

1518: -- Debug info.
1519: IF G_DEBUG='Y' THEN
1520: AHL_DEBUG_PUB.log_app_messages (
1521: x_msg_count, x_msg_data, 'SQL ERROR' );
1522: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Update Space ','+SPCBL+');
1523: -- Check if API is called in debug mode. If yes, disable debug.
1524: AHL_DEBUG_PUB.disable_debug;
1525: END IF;
1526: END Update_Space;

Line 1524: AHL_DEBUG_PUB.disable_debug;

1520: AHL_DEBUG_PUB.log_app_messages (
1521: x_msg_count, x_msg_data, 'SQL ERROR' );
1522: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_unavl_pvt.Update Space ','+SPCBL+');
1523: -- Check if API is called in debug mode. If yes, disable debug.
1524: AHL_DEBUG_PUB.disable_debug;
1525: END IF;
1526: END Update_Space;
1527:
1528: --------------------------------------------------------------------

Line 1592: AHL_DEBUG_PUB.enable_debug;

1588: -- Standard Start of API savepoint
1589: SAVEPOINT delete_space;
1590: -- Check if API is called in debug mode. If yes, enable debug.
1591: IF G_DEBUG='Y' THEN
1592: AHL_DEBUG_PUB.enable_debug;
1593: END IF;
1594: -- Debug info.
1595: IF G_DEBUG='Y' THEN
1596: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Delete Space','+SPCBL+');

Line 1596: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Delete Space','+SPCBL+');

1592: AHL_DEBUG_PUB.enable_debug;
1593: END IF;
1594: -- Debug info.
1595: IF G_DEBUG='Y' THEN
1596: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Delete Space','+SPCBL+');
1597: END IF;
1598: -- Standard call to check for call compatibility.
1599: IF FND_API.to_boolean(p_init_msg_list)
1600: THEN

Line 1692: Ahl_Debug_Pub.debug( 'End of private api Delete Space ','+SPCBL+');

1688: COMMIT;
1689: END IF;
1690: -- Debug info
1691: IF G_DEBUG='Y' THEN
1692: Ahl_Debug_Pub.debug( 'End of private api Delete Space ','+SPCBL+');
1693: -- Check if API is called in debug mode. If yes, disable debug.
1694: Ahl_Debug_Pub.disable_debug;
1695: END IF;
1696: --

Line 1694: Ahl_Debug_Pub.disable_debug;

1690: -- Debug info
1691: IF G_DEBUG='Y' THEN
1692: Ahl_Debug_Pub.debug( 'End of private api Delete Space ','+SPCBL+');
1693: -- Check if API is called in debug mode. If yes, disable debug.
1694: Ahl_Debug_Pub.disable_debug;
1695: END IF;
1696: --
1697: EXCEPTION
1698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1705: AHL_DEBUG_PUB.log_app_messages (

1701: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1702: p_count => x_msg_count,
1703: p_data => x_msg_data);
1704: IF G_DEBUG='Y' THEN
1705: AHL_DEBUG_PUB.log_app_messages (
1706: x_msg_count, x_msg_data, 'ERROR' );
1707: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');
1708: -- Check if API is called in debug mode. If yes, disable debug.
1709: AHL_DEBUG_PUB.disable_debug;

Line 1707: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');

1703: p_data => x_msg_data);
1704: IF G_DEBUG='Y' THEN
1705: AHL_DEBUG_PUB.log_app_messages (
1706: x_msg_count, x_msg_data, 'ERROR' );
1707: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');
1708: -- Check if API is called in debug mode. If yes, disable debug.
1709: AHL_DEBUG_PUB.disable_debug;
1710: END IF;
1711: WHEN FND_API.G_EXC_ERROR THEN

Line 1709: AHL_DEBUG_PUB.disable_debug;

1705: AHL_DEBUG_PUB.log_app_messages (
1706: x_msg_count, x_msg_data, 'ERROR' );
1707: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');
1708: -- Check if API is called in debug mode. If yes, disable debug.
1709: AHL_DEBUG_PUB.disable_debug;
1710: END IF;
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: ROLLBACK TO delete_space;
1713: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1719: AHL_DEBUG_PUB.log_app_messages (

1715: p_count => x_msg_count,
1716: p_data => X_msg_data);
1717: -- Debug info.
1718: IF G_DEBUG='Y' THEN
1719: AHL_DEBUG_PUB.log_app_messages (
1720: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1721: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');
1722: -- Check if API is called in debug mode. If yes, disable debug.
1723: AHL_DEBUG_PUB.disable_debug;

Line 1721: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');

1717: -- Debug info.
1718: IF G_DEBUG='Y' THEN
1719: AHL_DEBUG_PUB.log_app_messages (
1720: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1721: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');
1722: -- Check if API is called in debug mode. If yes, disable debug.
1723: AHL_DEBUG_PUB.disable_debug;
1724: END IF;
1725: WHEN OTHERS THEN

Line 1723: AHL_DEBUG_PUB.disable_debug;

1719: AHL_DEBUG_PUB.log_app_messages (
1720: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1721: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space ','+SPCBL+');
1722: -- Check if API is called in debug mode. If yes, disable debug.
1723: AHL_DEBUG_PUB.disable_debug;
1724: END IF;
1725: WHEN OTHERS THEN
1726: ROLLBACK TO delete_space;
1727: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1740: AHL_DEBUG_PUB.log_app_messages (

1736: p_data => X_msg_data);
1737:
1738: -- Debug info.
1739: IF G_DEBUG='Y' THEN
1740: AHL_DEBUG_PUB.log_app_messages (
1741: x_msg_count, x_msg_data, 'SQL ERROR' );
1742: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space','+SPCBL+');
1743: -- Check if API is called in debug mode. If yes, disable debug.
1744: AHL_DEBUG_PUB.disable_debug;

Line 1742: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space','+SPCBL+');

1738: -- Debug info.
1739: IF G_DEBUG='Y' THEN
1740: AHL_DEBUG_PUB.log_app_messages (
1741: x_msg_count, x_msg_data, 'SQL ERROR' );
1742: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space','+SPCBL+');
1743: -- Check if API is called in debug mode. If yes, disable debug.
1744: AHL_DEBUG_PUB.disable_debug;
1745: END IF;
1746: END Delete_Space;

Line 1744: AHL_DEBUG_PUB.disable_debug;

1740: AHL_DEBUG_PUB.log_app_messages (
1741: x_msg_count, x_msg_data, 'SQL ERROR' );
1742: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space','+SPCBL+');
1743: -- Check if API is called in debug mode. If yes, disable debug.
1744: AHL_DEBUG_PUB.disable_debug;
1745: END IF;
1746: END Delete_Space;
1747:
1748: --------------------------------------------------------------------

Line 1787: AHL_DEBUG_PUB.debug( 'inside conevrt orgid'||p_organization_id);

1783: WHERE concatenated_segments = p_item_description;
1784: END IF;
1785: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1786: IF G_DEBUG='Y' THEN
1787: AHL_DEBUG_PUB.debug( 'inside conevrt orgid'||p_organization_id);
1788: AHL_DEBUG_PUB.debug( 'iten id inside convert'||x_inventory_item_id);
1789: END IF;
1790: EXCEPTION
1791: WHEN NO_DATA_FOUND THEN

Line 1788: AHL_DEBUG_PUB.debug( 'iten id inside convert'||x_inventory_item_id);

1784: END IF;
1785: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1786: IF G_DEBUG='Y' THEN
1787: AHL_DEBUG_PUB.debug( 'inside conevrt orgid'||p_organization_id);
1788: AHL_DEBUG_PUB.debug( 'iten id inside convert'||x_inventory_item_id);
1789: END IF;
1790: EXCEPTION
1791: WHEN NO_DATA_FOUND THEN
1792: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

Line 1898: AHL_DEBUG_PUB.debug( 'inside complete orgid :'||p_space_capbl_rec.organization_id);

1894:
1895:
1896:
1897: IF G_DEBUG='Y' THEN
1898: AHL_DEBUG_PUB.debug( 'inside complete orgid :'||p_space_capbl_rec.organization_id);
1899: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.inventory_item_id);
1900: AHL_DEBUG_PUB.debug( 'inside complete visit :'||p_space_capbl_rec.inventory_item_id);
1901: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.visit_type_code);
1902: AHL_DEBUG_PUB.debug( 'inside complete spaceid :'||p_space_capbl_rec.space_id);

Line 1899: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.inventory_item_id);

1895:
1896:
1897: IF G_DEBUG='Y' THEN
1898: AHL_DEBUG_PUB.debug( 'inside complete orgid :'||p_space_capbl_rec.organization_id);
1899: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.inventory_item_id);
1900: AHL_DEBUG_PUB.debug( 'inside complete visit :'||p_space_capbl_rec.inventory_item_id);
1901: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.visit_type_code);
1902: AHL_DEBUG_PUB.debug( 'inside complete spaceid :'||p_space_capbl_rec.space_id);
1903: END IF;

Line 1900: AHL_DEBUG_PUB.debug( 'inside complete visit :'||p_space_capbl_rec.inventory_item_id);

1896:
1897: IF G_DEBUG='Y' THEN
1898: AHL_DEBUG_PUB.debug( 'inside complete orgid :'||p_space_capbl_rec.organization_id);
1899: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.inventory_item_id);
1900: AHL_DEBUG_PUB.debug( 'inside complete visit :'||p_space_capbl_rec.inventory_item_id);
1901: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.visit_type_code);
1902: AHL_DEBUG_PUB.debug( 'inside complete spaceid :'||p_space_capbl_rec.space_id);
1903: END IF;
1904:

Line 1901: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.visit_type_code);

1897: IF G_DEBUG='Y' THEN
1898: AHL_DEBUG_PUB.debug( 'inside complete orgid :'||p_space_capbl_rec.organization_id);
1899: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.inventory_item_id);
1900: AHL_DEBUG_PUB.debug( 'inside complete visit :'||p_space_capbl_rec.inventory_item_id);
1901: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.visit_type_code);
1902: AHL_DEBUG_PUB.debug( 'inside complete spaceid :'||p_space_capbl_rec.space_id);
1903: END IF;
1904:
1905: --Check for object version number

Line 1902: AHL_DEBUG_PUB.debug( 'inside complete spaceid :'||p_space_capbl_rec.space_id);

1898: AHL_DEBUG_PUB.debug( 'inside complete orgid :'||p_space_capbl_rec.organization_id);
1899: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.inventory_item_id);
1900: AHL_DEBUG_PUB.debug( 'inside complete visit :'||p_space_capbl_rec.inventory_item_id);
1901: AHL_DEBUG_PUB.debug( 'inside complete itemid :'||p_space_capbl_rec.visit_type_code);
1902: AHL_DEBUG_PUB.debug( 'inside complete spaceid :'||p_space_capbl_rec.space_id);
1903: END IF;
1904:
1905: --Check for object version number
1906: IF (l_space_capbl_rec.object_version_number <> p_space_capbl_rec.object_version_number)

Line 2002: AHL_DEBUG_PUB.debug( 'end complete orgid :'||x_space_capbl_rec.organization_id);

1998: x_space_capbl_rec.attribute15 := l_space_capbl_rec.attribute15;
1999: END IF;
2000:
2001: IF G_DEBUG='Y' THEN
2002: AHL_DEBUG_PUB.debug( 'end complete orgid :'||x_space_capbl_rec.organization_id);
2003: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.inventory_item_id);
2004: AHL_DEBUG_PUB.debug( 'end complete visit :'||x_space_capbl_rec.inventory_item_id);
2005: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.visit_type_code);
2006: AHL_DEBUG_PUB.debug( 'end complete spaceid :'||x_space_capbl_rec.space_id);

Line 2003: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.inventory_item_id);

1999: END IF;
2000:
2001: IF G_DEBUG='Y' THEN
2002: AHL_DEBUG_PUB.debug( 'end complete orgid :'||x_space_capbl_rec.organization_id);
2003: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.inventory_item_id);
2004: AHL_DEBUG_PUB.debug( 'end complete visit :'||x_space_capbl_rec.inventory_item_id);
2005: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.visit_type_code);
2006: AHL_DEBUG_PUB.debug( 'end complete spaceid :'||x_space_capbl_rec.space_id);
2007: END IF;

Line 2004: AHL_DEBUG_PUB.debug( 'end complete visit :'||x_space_capbl_rec.inventory_item_id);

2000:
2001: IF G_DEBUG='Y' THEN
2002: AHL_DEBUG_PUB.debug( 'end complete orgid :'||x_space_capbl_rec.organization_id);
2003: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.inventory_item_id);
2004: AHL_DEBUG_PUB.debug( 'end complete visit :'||x_space_capbl_rec.inventory_item_id);
2005: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.visit_type_code);
2006: AHL_DEBUG_PUB.debug( 'end complete spaceid :'||x_space_capbl_rec.space_id);
2007: END IF;
2008:

Line 2005: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.visit_type_code);

2001: IF G_DEBUG='Y' THEN
2002: AHL_DEBUG_PUB.debug( 'end complete orgid :'||x_space_capbl_rec.organization_id);
2003: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.inventory_item_id);
2004: AHL_DEBUG_PUB.debug( 'end complete visit :'||x_space_capbl_rec.inventory_item_id);
2005: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.visit_type_code);
2006: AHL_DEBUG_PUB.debug( 'end complete spaceid :'||x_space_capbl_rec.space_id);
2007: END IF;
2008:
2009: END Complete_Space_Capbl_Rec;

Line 2006: AHL_DEBUG_PUB.debug( 'end complete spaceid :'||x_space_capbl_rec.space_id);

2002: AHL_DEBUG_PUB.debug( 'end complete orgid :'||x_space_capbl_rec.organization_id);
2003: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.inventory_item_id);
2004: AHL_DEBUG_PUB.debug( 'end complete visit :'||x_space_capbl_rec.inventory_item_id);
2005: AHL_DEBUG_PUB.debug( 'end complete itemid :'||x_space_capbl_rec.visit_type_code);
2006: AHL_DEBUG_PUB.debug( 'end complete spaceid :'||x_space_capbl_rec.space_id);
2007: END IF;
2008:
2009: END Complete_Space_Capbl_Rec;
2010:

Line 2118: AHL_DEBUG_PUB.debug( 'org id invalidation:'||p_space_capbl_rec.organization_id);

2114: END IF;
2115: END IF; */
2116:
2117: IF G_DEBUG='Y' THEN
2118: AHL_DEBUG_PUB.debug( 'org id invalidation:'||p_space_capbl_rec.organization_id);
2119: AHL_DEBUG_PUB.debug( 'item id valid 1:'||p_space_capbl_rec.inventory_item_id);
2120: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capbl_rec.visit_type_code);
2121: AHL_DEBUG_PUB.debug( 'space valid 1:'||p_space_capbl_rec.space_id);
2122: END IF;

Line 2119: AHL_DEBUG_PUB.debug( 'item id valid 1:'||p_space_capbl_rec.inventory_item_id);

2115: END IF; */
2116:
2117: IF G_DEBUG='Y' THEN
2118: AHL_DEBUG_PUB.debug( 'org id invalidation:'||p_space_capbl_rec.organization_id);
2119: AHL_DEBUG_PUB.debug( 'item id valid 1:'||p_space_capbl_rec.inventory_item_id);
2120: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capbl_rec.visit_type_code);
2121: AHL_DEBUG_PUB.debug( 'space valid 1:'||p_space_capbl_rec.space_id);
2122: END IF;
2123:

Line 2120: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capbl_rec.visit_type_code);

2116:
2117: IF G_DEBUG='Y' THEN
2118: AHL_DEBUG_PUB.debug( 'org id invalidation:'||p_space_capbl_rec.organization_id);
2119: AHL_DEBUG_PUB.debug( 'item id valid 1:'||p_space_capbl_rec.inventory_item_id);
2120: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capbl_rec.visit_type_code);
2121: AHL_DEBUG_PUB.debug( 'space valid 1:'||p_space_capbl_rec.space_id);
2122: END IF;
2123:
2124: --Check for Unique Record

Line 2121: AHL_DEBUG_PUB.debug( 'space valid 1:'||p_space_capbl_rec.space_id);

2117: IF G_DEBUG='Y' THEN
2118: AHL_DEBUG_PUB.debug( 'org id invalidation:'||p_space_capbl_rec.organization_id);
2119: AHL_DEBUG_PUB.debug( 'item id valid 1:'||p_space_capbl_rec.inventory_item_id);
2120: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capbl_rec.visit_type_code);
2121: AHL_DEBUG_PUB.debug( 'space valid 1:'||p_space_capbl_rec.space_id);
2122: END IF;
2123:
2124: --Check for Unique Record
2125: IF p_space_capbl_rec.visit_type_code IS NOT NULL THEN

Line 2344: AHL_DEBUG_PUB.enable_debug;

2340: -- Standard Start of API savepoint
2341: SAVEPOINT create_space_capblts;
2342: -- Check if API is called in debug mode. If yes, enable debug.
2343: IF G_DEBUG='Y' THEN
2344: AHL_DEBUG_PUB.enable_debug;
2345: END IF;
2346: -- Debug info.
2347: IF G_DEBUG='Y' THEN
2348: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Create Space Capblts ','+SPCBL+');

Line 2348: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Create Space Capblts ','+SPCBL+');

2344: AHL_DEBUG_PUB.enable_debug;
2345: END IF;
2346: -- Debug info.
2347: IF G_DEBUG='Y' THEN
2348: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Create Space Capblts ','+SPCBL+');
2349: END IF;
2350: -- Standard call to check for call compatibility.
2351: IF FND_API.to_boolean(p_init_msg_list)
2352: THEN

Line 2366: AHL_DEBUG_PUB.debug( 'org name 1:'||p_x_space_capblts_rec.org_name);

2362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2363: END IF;
2364:
2365: IF G_DEBUG='Y' THEN
2366: AHL_DEBUG_PUB.debug( 'org name 1:'||p_x_space_capblts_rec.org_name);
2367: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_x_space_capblts_rec.item_Description);
2368: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_x_space_capblts_rec.visit_type_code);
2369: AHL_DEBUG_PUB.debug( 'space 1:'||p_x_space_capblts_rec.space_name);
2370: END IF;

Line 2367: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_x_space_capblts_rec.item_Description);

2363: END IF;
2364:
2365: IF G_DEBUG='Y' THEN
2366: AHL_DEBUG_PUB.debug( 'org name 1:'||p_x_space_capblts_rec.org_name);
2367: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_x_space_capblts_rec.item_Description);
2368: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_x_space_capblts_rec.visit_type_code);
2369: AHL_DEBUG_PUB.debug( 'space 1:'||p_x_space_capblts_rec.space_name);
2370: END IF;
2371:

Line 2368: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_x_space_capblts_rec.visit_type_code);

2364:
2365: IF G_DEBUG='Y' THEN
2366: AHL_DEBUG_PUB.debug( 'org name 1:'||p_x_space_capblts_rec.org_name);
2367: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_x_space_capblts_rec.item_Description);
2368: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_x_space_capblts_rec.visit_type_code);
2369: AHL_DEBUG_PUB.debug( 'space 1:'||p_x_space_capblts_rec.space_name);
2370: END IF;
2371:
2372: --------------------Value OR ID conversion---------------------------

Line 2369: AHL_DEBUG_PUB.debug( 'space 1:'||p_x_space_capblts_rec.space_name);

2365: IF G_DEBUG='Y' THEN
2366: AHL_DEBUG_PUB.debug( 'org name 1:'||p_x_space_capblts_rec.org_name);
2367: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_x_space_capblts_rec.item_Description);
2368: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_x_space_capblts_rec.visit_type_code);
2369: AHL_DEBUG_PUB.debug( 'space 1:'||p_x_space_capblts_rec.space_name);
2370: END IF;
2371:
2372: --------------------Value OR ID conversion---------------------------
2373: --Start API Body

Line 2429: AHL_DEBUG_PUB.debug( 'org id '||p_x_space_capblts_rec.organization_id);

2425: p_x_space_capblts_rec.organization_id := l_organization_id;
2426: */
2427:
2428: IF G_DEBUG='Y' THEN
2429: AHL_DEBUG_PUB.debug( 'org id '||p_x_space_capblts_rec.organization_id);
2430: AHL_DEBUG_PUB.debug( 'ietm desc '||p_x_space_capblts_rec.item_description);
2431: AHL_DEBUG_PUB.debug( 'space id '||p_x_space_capblts_rec.space_id);
2432: END IF;
2433: --Get organization id

Line 2430: AHL_DEBUG_PUB.debug( 'ietm desc '||p_x_space_capblts_rec.item_description);

2426: */
2427:
2428: IF G_DEBUG='Y' THEN
2429: AHL_DEBUG_PUB.debug( 'org id '||p_x_space_capblts_rec.organization_id);
2430: AHL_DEBUG_PUB.debug( 'ietm desc '||p_x_space_capblts_rec.item_description);
2431: AHL_DEBUG_PUB.debug( 'space id '||p_x_space_capblts_rec.space_id);
2432: END IF;
2433: --Get organization id
2434: OPEN get_org_cur(l_space_id);

Line 2431: AHL_DEBUG_PUB.debug( 'space id '||p_x_space_capblts_rec.space_id);

2427:
2428: IF G_DEBUG='Y' THEN
2429: AHL_DEBUG_PUB.debug( 'org id '||p_x_space_capblts_rec.organization_id);
2430: AHL_DEBUG_PUB.debug( 'ietm desc '||p_x_space_capblts_rec.item_description);
2431: AHL_DEBUG_PUB.debug( 'space id '||p_x_space_capblts_rec.space_id);
2432: END IF;
2433: --Get organization id
2434: OPEN get_org_cur(l_space_id);
2435: FETCH get_org_cur INTO l_organization_id;

Line 2470: AHL_DEBUG_PUB.debug( 'item id '||l_inventory_item_id);

2466: --Assign the returned value
2467: -- p_x_space_capblts_rec.inventory_item_id := l_inventory_item_id;
2468:
2469: IF G_DEBUG='Y' THEN
2470: AHL_DEBUG_PUB.debug( 'item id '||l_inventory_item_id);
2471: AHL_DEBUG_PUB.debug( 'visit type '||p_x_space_capblts_rec.visit_type_code);
2472: END IF;
2473:
2474: --For Visit Type

Line 2471: AHL_DEBUG_PUB.debug( 'visit type '||p_x_space_capblts_rec.visit_type_code);

2467: -- p_x_space_capblts_rec.inventory_item_id := l_inventory_item_id;
2468:
2469: IF G_DEBUG='Y' THEN
2470: AHL_DEBUG_PUB.debug( 'item id '||l_inventory_item_id);
2471: AHL_DEBUG_PUB.debug( 'visit type '||p_x_space_capblts_rec.visit_type_code);
2472: END IF;
2473:
2474: --For Visit Type
2475: IF p_x_space_capblts_rec.visit_type_mean IS NOT NULL AND

Line 2506: AHL_DEBUG_PUB.debug( 'after space id '||p_x_space_capblts_rec.space_id);

2502: -- Assign return value
2503: p_x_space_capblts_rec.visit_type_code := l_space_capblts_rec.visit_type_code;
2504:
2505: IF G_DEBUG='Y' THEN
2506: AHL_DEBUG_PUB.debug( 'after space id '||p_x_space_capblts_rec.space_id);
2507: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);
2508: AHL_DEBUG_PUB.debug( 'after item id '||p_x_space_capblts_rec.inventory_item_id);
2509:
2510: END IF;

Line 2507: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);

2503: p_x_space_capblts_rec.visit_type_code := l_space_capblts_rec.visit_type_code;
2504:
2505: IF G_DEBUG='Y' THEN
2506: AHL_DEBUG_PUB.debug( 'after space id '||p_x_space_capblts_rec.space_id);
2507: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);
2508: AHL_DEBUG_PUB.debug( 'after item id '||p_x_space_capblts_rec.inventory_item_id);
2509:
2510: END IF;
2511:

Line 2508: AHL_DEBUG_PUB.debug( 'after item id '||p_x_space_capblts_rec.inventory_item_id);

2504:
2505: IF G_DEBUG='Y' THEN
2506: AHL_DEBUG_PUB.debug( 'after space id '||p_x_space_capblts_rec.space_id);
2507: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);
2508: AHL_DEBUG_PUB.debug( 'after item id '||p_x_space_capblts_rec.inventory_item_id);
2509:
2510: END IF;
2511:
2512: --Standard check to count messages

Line 2529: AHL_DEBUG_PUB.debug( 'after assign space id '||l_space_capblts_rec.space_id);

2525: x_space_capbl_rec => l_space_capblts_rec
2526: );
2527:
2528: IF G_DEBUG='Y' THEN
2529: AHL_DEBUG_PUB.debug( 'after assign space id '||l_space_capblts_rec.space_id);
2530: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);
2531: AHL_DEBUG_PUB.debug( 'after assign item '||l_space_capblts_rec.inventory_item_id);
2532: END IF;
2533:

Line 2530: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);

2526: );
2527:
2528: IF G_DEBUG='Y' THEN
2529: AHL_DEBUG_PUB.debug( 'after assign space id '||l_space_capblts_rec.space_id);
2530: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);
2531: AHL_DEBUG_PUB.debug( 'after assign item '||l_space_capblts_rec.inventory_item_id);
2532: END IF;
2533:
2534: -- Call Validate space rec input attributes

Line 2531: AHL_DEBUG_PUB.debug( 'after assign item '||l_space_capblts_rec.inventory_item_id);

2527:
2528: IF G_DEBUG='Y' THEN
2529: AHL_DEBUG_PUB.debug( 'after assign space id '||l_space_capblts_rec.space_id);
2530: AHL_DEBUG_PUB.debug( 'after visit type '||l_space_capblts_rec.visit_type_code);
2531: AHL_DEBUG_PUB.debug( 'after assign item '||l_space_capblts_rec.inventory_item_id);
2532: END IF;
2533:
2534: -- Call Validate space rec input attributes
2535:

Line 2772: Ahl_Debug_Pub.debug( 'End of private api Create Space Capblts ','+SPCBL+');

2768: COMMIT;
2769: END IF;
2770: -- Debug info
2771: IF G_DEBUG='Y' THEN
2772: Ahl_Debug_Pub.debug( 'End of private api Create Space Capblts ','+SPCBL+');
2773: -- Check if API is called in debug mode. If yes, disable debug.
2774: Ahl_Debug_Pub.disable_debug;
2775: END IF;
2776:

Line 2774: Ahl_Debug_Pub.disable_debug;

2770: -- Debug info
2771: IF G_DEBUG='Y' THEN
2772: Ahl_Debug_Pub.debug( 'End of private api Create Space Capblts ','+SPCBL+');
2773: -- Check if API is called in debug mode. If yes, disable debug.
2774: Ahl_Debug_Pub.disable_debug;
2775: END IF;
2776:
2777: EXCEPTION
2778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2786: AHL_DEBUG_PUB.log_app_messages (

2782: p_count => x_msg_count,
2783: p_data => x_msg_data);
2784:
2785: IF G_DEBUG='Y' THEN
2786: AHL_DEBUG_PUB.log_app_messages (
2787: x_msg_count, x_msg_data, 'ERROR' );
2788: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2789: -- Check if API is called in debug mode. If yes, disable debug.
2790: AHL_DEBUG_PUB.disable_debug;

Line 2788: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');

2784:
2785: IF G_DEBUG='Y' THEN
2786: AHL_DEBUG_PUB.log_app_messages (
2787: x_msg_count, x_msg_data, 'ERROR' );
2788: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2789: -- Check if API is called in debug mode. If yes, disable debug.
2790: AHL_DEBUG_PUB.disable_debug;
2791: END IF;
2792: WHEN FND_API.G_EXC_ERROR THEN

Line 2790: AHL_DEBUG_PUB.disable_debug;

2786: AHL_DEBUG_PUB.log_app_messages (
2787: x_msg_count, x_msg_data, 'ERROR' );
2788: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2789: -- Check if API is called in debug mode. If yes, disable debug.
2790: AHL_DEBUG_PUB.disable_debug;
2791: END IF;
2792: WHEN FND_API.G_EXC_ERROR THEN
2793: ROLLBACK TO create_space_capblts;
2794: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2800: AHL_DEBUG_PUB.log_app_messages (

2796: p_count => x_msg_count,
2797: p_data => X_msg_data);
2798: -- Debug info.
2799: IF G_DEBUG='Y' THEN
2800: AHL_DEBUG_PUB.log_app_messages (
2801: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2802: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2803: END IF;
2804: -- Check if API is called in debug mode. If yes, disable debug.

Line 2802: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');

2798: -- Debug info.
2799: IF G_DEBUG='Y' THEN
2800: AHL_DEBUG_PUB.log_app_messages (
2801: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2802: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2803: END IF;
2804: -- Check if API is called in debug mode. If yes, disable debug.
2805: AHL_DEBUG_PUB.disable_debug;
2806:

Line 2805: AHL_DEBUG_PUB.disable_debug;

2801: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2802: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2803: END IF;
2804: -- Check if API is called in debug mode. If yes, disable debug.
2805: AHL_DEBUG_PUB.disable_debug;
2806:
2807: WHEN OTHERS THEN
2808: ROLLBACK TO create_space_capblts;
2809: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2822: AHL_DEBUG_PUB.log_app_messages (

2818: p_data => X_msg_data);
2819:
2820: -- Debug info.
2821: IF G_DEBUG='Y' THEN
2822: AHL_DEBUG_PUB.log_app_messages (
2823: x_msg_count, x_msg_data, 'SQL ERROR' );
2824: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2825: END IF;
2826: -- Check if API is called in debug mode. If yes, disable debug.

Line 2824: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');

2820: -- Debug info.
2821: IF G_DEBUG='Y' THEN
2822: AHL_DEBUG_PUB.log_app_messages (
2823: x_msg_count, x_msg_data, 'SQL ERROR' );
2824: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2825: END IF;
2826: -- Check if API is called in debug mode. If yes, disable debug.
2827: AHL_DEBUG_PUB.disable_debug;
2828:

Line 2827: AHL_DEBUG_PUB.disable_debug;

2823: x_msg_count, x_msg_data, 'SQL ERROR' );
2824: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Create Space Capblts','+SPCBL+');
2825: END IF;
2826: -- Check if API is called in debug mode. If yes, disable debug.
2827: AHL_DEBUG_PUB.disable_debug;
2828:
2829: END Create_Space_Capblts;
2830:
2831: --------------------------------------------------------------------

Line 2883: AHL_DEBUG_PUB.enable_debug;

2879: -- Standard Start of API savepoint
2880: SAVEPOINT update_space_capblts;
2881: -- Check if API is called in debug mode. If yes, enable debug.
2882: IF G_DEBUG='Y' THEN
2883: AHL_DEBUG_PUB.enable_debug;
2884: END IF;
2885: -- Debug info.
2886: IF G_DEBUG='Y' THEN
2887: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');

Line 2887: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');

2883: AHL_DEBUG_PUB.enable_debug;
2884: END IF;
2885: -- Debug info.
2886: IF G_DEBUG='Y' THEN
2887: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
2888: END IF;
2889: -- Standard call to check for call compatibility.
2890: IF FND_API.to_boolean(p_init_msg_list)
2891: THEN

Line 2907: AHL_DEBUG_PUB.debug( 'org name 1:'||p_space_capblts_rec.org_name);

2903:
2904: ---------------------art API Body------------------------------------
2905:
2906: IF G_DEBUG='Y' THEN
2907: AHL_DEBUG_PUB.debug( 'org name 1:'||p_space_capblts_rec.org_name);
2908: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_space_capblts_rec.item_Description);
2909: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capblts_rec.visit_type_mean);
2910:
2911: END IF;

Line 2908: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_space_capblts_rec.item_Description);

2904: ---------------------art API Body------------------------------------
2905:
2906: IF G_DEBUG='Y' THEN
2907: AHL_DEBUG_PUB.debug( 'org name 1:'||p_space_capblts_rec.org_name);
2908: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_space_capblts_rec.item_Description);
2909: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capblts_rec.visit_type_mean);
2910:
2911: END IF;
2912:

Line 2909: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capblts_rec.visit_type_mean);

2905:
2906: IF G_DEBUG='Y' THEN
2907: AHL_DEBUG_PUB.debug( 'org name 1:'||p_space_capblts_rec.org_name);
2908: AHL_DEBUG_PUB.debug( 'item desc 1:'||p_space_capblts_rec.item_Description);
2909: AHL_DEBUG_PUB.debug( 'visit type 1:'||p_space_capblts_rec.visit_type_mean);
2910:
2911: END IF;
2912:
2913: --------------------Value OR ID conversion---------------------------

Line 3097: Ahl_Debug_Pub.debug( 'End of private api Update Space Capblts','+SPCBL+');

3093: COMMIT;
3094: END IF;
3095: -- Debug info
3096: IF G_DEBUG='Y' THEN
3097: Ahl_Debug_Pub.debug( 'End of private api Update Space Capblts','+SPCBL+');
3098: -- Check if API is called in debug mode. If yes, disable debug.
3099: Ahl_Debug_Pub.disable_debug;
3100: END IF;
3101:

Line 3099: Ahl_Debug_Pub.disable_debug;

3095: -- Debug info
3096: IF G_DEBUG='Y' THEN
3097: Ahl_Debug_Pub.debug( 'End of private api Update Space Capblts','+SPCBL+');
3098: -- Check if API is called in debug mode. If yes, disable debug.
3099: Ahl_Debug_Pub.disable_debug;
3100: END IF;
3101:
3102: EXCEPTION
3103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3111: AHL_DEBUG_PUB.log_app_messages (

3107: p_count => x_msg_count,
3108: p_data => x_msg_data);
3109:
3110: IF G_DEBUG='Y' THEN
3111: AHL_DEBUG_PUB.log_app_messages (
3112: x_msg_count, x_msg_data, 'ERROR' );
3113: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3114: END IF;
3115: -- Check if API is called in debug mode. If yes, disable debug.

Line 3113: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');

3109:
3110: IF G_DEBUG='Y' THEN
3111: AHL_DEBUG_PUB.log_app_messages (
3112: x_msg_count, x_msg_data, 'ERROR' );
3113: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3114: END IF;
3115: -- Check if API is called in debug mode. If yes, disable debug.
3116: AHL_DEBUG_PUB.disable_debug;
3117:

Line 3116: AHL_DEBUG_PUB.disable_debug;

3112: x_msg_count, x_msg_data, 'ERROR' );
3113: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3114: END IF;
3115: -- Check if API is called in debug mode. If yes, disable debug.
3116: AHL_DEBUG_PUB.disable_debug;
3117:
3118: WHEN FND_API.G_EXC_ERROR THEN
3119: ROLLBACK TO update_space_capblts;
3120: X_return_status := FND_API.G_RET_STS_ERROR;

Line 3126: AHL_DEBUG_PUB.log_app_messages (

3122: p_count => x_msg_count,
3123: p_data => X_msg_data);
3124: -- Debug info.
3125: IF G_DEBUG='Y' THEN
3126: AHL_DEBUG_PUB.log_app_messages (
3127: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3128: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3129: END IF;
3130: -- Check if API is called in debug mode. If yes, disable debug.

Line 3128: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');

3124: -- Debug info.
3125: IF G_DEBUG='Y' THEN
3126: AHL_DEBUG_PUB.log_app_messages (
3127: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3128: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3129: END IF;
3130: -- Check if API is called in debug mode. If yes, disable debug.
3131: AHL_DEBUG_PUB.disable_debug;
3132:

Line 3131: AHL_DEBUG_PUB.disable_debug;

3127: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3128: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3129: END IF;
3130: -- Check if API is called in debug mode. If yes, disable debug.
3131: AHL_DEBUG_PUB.disable_debug;
3132:
3133: WHEN OTHERS THEN
3134: ROLLBACK TO update_space_capblts;
3135: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3148: AHL_DEBUG_PUB.log_app_messages (

3144: p_data => X_msg_data);
3145:
3146: -- Debug info.
3147: IF G_DEBUG='Y' THEN
3148: AHL_DEBUG_PUB.log_app_messages (
3149: x_msg_count, x_msg_data, 'SQL ERROR' );
3150: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3151: END IF;
3152: -- Check if API is called in debug mode. If yes, disable debug.

Line 3150: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');

3146: -- Debug info.
3147: IF G_DEBUG='Y' THEN
3148: AHL_DEBUG_PUB.log_app_messages (
3149: x_msg_count, x_msg_data, 'SQL ERROR' );
3150: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3151: END IF;
3152: -- Check if API is called in debug mode. If yes, disable debug.
3153: AHL_DEBUG_PUB.disable_debug;
3154:

Line 3153: AHL_DEBUG_PUB.disable_debug;

3149: x_msg_count, x_msg_data, 'SQL ERROR' );
3150: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Update Space Capblts','+SPCBL+');
3151: END IF;
3152: -- Check if API is called in debug mode. If yes, disable debug.
3153: AHL_DEBUG_PUB.disable_debug;
3154:
3155: END Update_Space_Capblts;
3156:
3157: --------------------------------------------------------------------

Line 3227: AHL_DEBUG_PUB.enable_debug;

3223: -- Standard Start of API savepoint
3224: SAVEPOINT delete_space_capblts;
3225: -- Check if API is called in debug mode. If yes, enable debug.
3226: IF G_DEBUG='Y' THEN
3227: AHL_DEBUG_PUB.enable_debug;
3228: END IF;
3229: -- Debug info.
3230: IF G_DEBUG='Y' THEN
3231: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');

Line 3231: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');

3227: AHL_DEBUG_PUB.enable_debug;
3228: END IF;
3229: -- Debug info.
3230: IF G_DEBUG='Y' THEN
3231: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3232: END IF;
3233: -- Standard call to check for call compatibility.
3234: IF FND_API.to_boolean(p_init_msg_list)
3235: THEN

Line 3292: AHL_DEBUG_PUB.debug( 'before delete capabilities');

3288: CLOSE space_assign_cur;
3289:
3290: --
3291: IF G_DEBUG='Y' THEN
3292: AHL_DEBUG_PUB.debug( 'before delete capabilities');
3293: END IF;
3294: -------------------Remove the reocrd from space capabilities------------
3295: DELETE FROM AHL_SPACE_CAPABILITIES
3296: WHERE SPACE_CAPABILITY_ID = l_space_capability_id;

Line 3314: Ahl_Debug_Pub.debug( 'End of private api Delete Space Capblts','+SPCBL+');

3310: COMMIT;
3311: END IF;
3312: -- Debug info
3313: IF G_DEBUG='Y' THEN
3314: Ahl_Debug_Pub.debug( 'End of private api Delete Space Capblts','+SPCBL+');
3315: -- Check if API is called in debug mode. If yes, disable debug.
3316: Ahl_Debug_Pub.disable_debug;
3317: END IF;
3318:

Line 3316: Ahl_Debug_Pub.disable_debug;

3312: -- Debug info
3313: IF G_DEBUG='Y' THEN
3314: Ahl_Debug_Pub.debug( 'End of private api Delete Space Capblts','+SPCBL+');
3315: -- Check if API is called in debug mode. If yes, disable debug.
3316: Ahl_Debug_Pub.disable_debug;
3317: END IF;
3318:
3319: EXCEPTION
3320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3327: AHL_DEBUG_PUB.log_app_messages (

3323: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3324: p_count => x_msg_count,
3325: p_data => x_msg_data);
3326: IF G_DEBUG='Y' THEN
3327: AHL_DEBUG_PUB.log_app_messages (
3328: x_msg_count, x_msg_data, 'ERROR' );
3329: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3330: -- Check if API is called in debug mode. If yes, disable debug.
3331: AHL_DEBUG_PUB.disable_debug;

Line 3329: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');

3325: p_data => x_msg_data);
3326: IF G_DEBUG='Y' THEN
3327: AHL_DEBUG_PUB.log_app_messages (
3328: x_msg_count, x_msg_data, 'ERROR' );
3329: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3330: -- Check if API is called in debug mode. If yes, disable debug.
3331: AHL_DEBUG_PUB.disable_debug;
3332: END IF;
3333: WHEN FND_API.G_EXC_ERROR THEN

Line 3331: AHL_DEBUG_PUB.disable_debug;

3327: AHL_DEBUG_PUB.log_app_messages (
3328: x_msg_count, x_msg_data, 'ERROR' );
3329: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3330: -- Check if API is called in debug mode. If yes, disable debug.
3331: AHL_DEBUG_PUB.disable_debug;
3332: END IF;
3333: WHEN FND_API.G_EXC_ERROR THEN
3334: ROLLBACK TO delete_space_capblts;
3335: X_return_status := FND_API.G_RET_STS_ERROR;

Line 3341: AHL_DEBUG_PUB.log_app_messages (

3337: p_count => x_msg_count,
3338: p_data => X_msg_data);
3339: IF G_DEBUG='Y' THEN
3340: -- Debug info.
3341: AHL_DEBUG_PUB.log_app_messages (
3342: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3343: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3344: -- Check if API is called in debug mode. If yes, disable debug.
3345: AHL_DEBUG_PUB.disable_debug;

Line 3343: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');

3339: IF G_DEBUG='Y' THEN
3340: -- Debug info.
3341: AHL_DEBUG_PUB.log_app_messages (
3342: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3343: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3344: -- Check if API is called in debug mode. If yes, disable debug.
3345: AHL_DEBUG_PUB.disable_debug;
3346: END IF;
3347: WHEN OTHERS THEN

Line 3345: AHL_DEBUG_PUB.disable_debug;

3341: AHL_DEBUG_PUB.log_app_messages (
3342: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3343: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3344: -- Check if API is called in debug mode. If yes, disable debug.
3345: AHL_DEBUG_PUB.disable_debug;
3346: END IF;
3347: WHEN OTHERS THEN
3348: ROLLBACK TO delete_space_capblts;
3349: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3362: AHL_DEBUG_PUB.log_app_messages (

3358: p_data => X_msg_data);
3359:
3360: IF G_DEBUG='Y' THEN
3361: -- Debug info.
3362: AHL_DEBUG_PUB.log_app_messages (
3363: x_msg_count, x_msg_data, 'SQL ERROR' );
3364: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3365: -- Check if API is called in debug mode. If yes, disable debug.
3366: AHL_DEBUG_PUB.disable_debug;

Line 3364: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');

3360: IF G_DEBUG='Y' THEN
3361: -- Debug info.
3362: AHL_DEBUG_PUB.log_app_messages (
3363: x_msg_count, x_msg_data, 'SQL ERROR' );
3364: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3365: -- Check if API is called in debug mode. If yes, disable debug.
3366: AHL_DEBUG_PUB.disable_debug;
3367: END IF;
3368: END Delete_Space_Capblts;

Line 3366: AHL_DEBUG_PUB.disable_debug;

3362: AHL_DEBUG_PUB.log_app_messages (
3363: x_msg_count, x_msg_data, 'SQL ERROR' );
3364: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_capb_pvt.Delete Space Capblts','+SPCBL+');
3365: -- Check if API is called in debug mode. If yes, disable debug.
3366: AHL_DEBUG_PUB.disable_debug;
3367: END IF;
3368: END Delete_Space_Capblts;
3369:
3370: END AHL_LTP_SPACE_CAPB_PVT;