[Home] [Help]
654: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
655: l_return_status VARCHAR2(1);
656: l_space_assign_rec space_assignment_rec;
657: BEGIN
658: -- Standard call to check for call compatibility.
659: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version,
660: p_api_version,
661: l_api_name,
662: G_PKG_NAME)
773: WHERE space_assignment_id = x_id);
774: --
775: BEGIN
776: --------------------Initialize ----------------------------------
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;
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
790: FND_MSG_PUB.initialize;
791: END IF;
867: END IF;
868: --Assign the returned value
869: p_x_space_assign_rec.visit_id := l_visit_id;
870:
871: --Standard check to count messages
872: l_msg_count := Fnd_Msg_Pub.count_msg;
873:
874: IF l_msg_count > 0 THEN
875: X_msg_count := l_msg_count;
893: x_msg_count => l_msg_count,
894: x_msg_data => l_msg_data );
895:
896:
897: --Standard check to count messages
898: l_msg_count := Fnd_Msg_Pub.count_msg;
899:
900: IF l_msg_count > 0 THEN
901: X_msg_count := l_msg_count;
1039: ELSE
1040: l_space_assign_rec.attribute15 := p_x_space_assign_rec.attribute15;
1041: END IF;
1042: END IF;
1043: --Standard check to count messages
1044: l_msg_count := Fnd_Msg_Pub.count_msg;
1045:
1046: IF l_msg_count > 0 THEN
1047: X_msg_count := l_msg_count;
1111: );
1112:
1113: p_x_space_assign_rec.space_assignment_id := l_space_assignment_id;
1114: ---------------------------End of Body---------------------------------------
1115: --Standard check to count messages
1116: l_msg_count := Fnd_Msg_Pub.count_msg;
1117:
1118: IF l_msg_count > 0 THEN
1119: X_msg_count := l_msg_count;
1120: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1121: RAISE Fnd_Api.G_EXC_ERROR;
1122: END IF;
1123:
1124: --Standard check for commit
1125: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1126: COMMIT;
1127: END IF;
1128: -- Debug info
1218: l_space_assign_rec Space_Assignment_Rec;
1219:
1220: BEGIN
1221: --------------------Initialize ----------------------------------
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;
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
1235: FND_MSG_PUB.initialize;
1236: END IF;
1340: WHERE space_assignment_id = p_space_assign_rec.space_assignment_id;
1341:
1342:
1343: ---------------------------End of Body---------------------------------------
1344: --Standard check to count messages
1345: l_msg_count := Fnd_Msg_Pub.count_msg;
1346:
1347: IF l_msg_count > 0 THEN
1348: X_msg_count := l_msg_count;
1349: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1350: RAISE Fnd_Api.G_EXC_ERROR;
1351: END IF;
1352:
1353: --Standard check for commit
1354: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1355: COMMIT;
1356: END IF;
1357: -- Debug info
1491: l_visit_spaces_rec c_visit_spaces_cur%ROWTYPE;
1492:
1493: BEGIN
1494: --------------------Initialize ----------------------------------
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;
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
1508: FND_MSG_PUB.initialize;
1509: END IF;
1596: DELETE FROM AHL_SPACE_ASSIGNMENTS
1597: WHERE SPACE_ASSIGNMENT_ID = p_space_assign_rec.space_assignment_id;
1598: END IF;
1599: ---------------------------End of Body---------------------------------------
1600: --Standard check to count messages
1601: l_msg_count := Fnd_Msg_Pub.count_msg;
1602:
1603: IF l_msg_count > 0 THEN
1604: X_msg_count := l_msg_count;
1605: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1606: RAISE Fnd_Api.G_EXC_ERROR;
1607: END IF;
1608:
1609: --Standard check for commit
1610: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1611: COMMIT;
1612: END IF;
1613: -- Debug info
1785: );
1786: END IF;
1787:
1788: --------------------Initialize ----------------------------------
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;
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
1802: FND_MSG_PUB.initialize;
1803: END IF;
2029: END IF; --dept condtion
2030: END IF; --org condition
2031: END IF; --Schedule flag
2032: */
2033: --Standard check to count messages
2034: l_msg_count := Fnd_Msg_Pub.count_msg;
2035:
2036: IF l_msg_count > 0 THEN
2037: X_msg_count := l_msg_count;
2090: FETCH c_visit_sched_cur INTO l_dummy;
2091: CLOSE c_visit_sched_cur;
2092: */
2093:
2094: --Standard check to count messages
2095: l_msg_count := Fnd_Msg_Pub.count_msg;
2096:
2097: IF l_msg_count > 0 THEN
2098: X_msg_count := l_msg_count;
2211: x_msg_data => l_msg_data);
2212:
2213: END IF;
2214: */
2215: --Standard check to count messages
2216: l_msg_count := Fnd_Msg_Pub.count_msg;
2217:
2218: IF l_msg_count > 0 THEN
2219: X_msg_count := l_msg_count;
2222: END IF;
2223:
2224: ---------------------------End of Body---------------------------------------
2225:
2226: --Standard check for commit
2227: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2228: COMMIT;
2229: END IF;
2230: -- Debug info
2373: i NUMBER := 0;
2374: l_visit_name VARCHAR2(80);
2375: BEGIN
2376: --------------------Initialize ----------------------------------
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;
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
2390: FND_MSG_PUB.initialize;
2391: END IF;
2574:
2575: -- Changes by mpothuku End
2576:
2577: ---------------------------End of Body---------------------------------------
2578: --Standard check to count messages
2579: l_msg_count := Fnd_Msg_Pub.count_msg;
2580:
2581: IF l_msg_count > 0 THEN
2582: X_msg_count := l_msg_count;
2583: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2584: RAISE Fnd_Api.G_EXC_ERROR;
2585: END IF;
2586:
2587: --Standard check for commit
2588: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2589: COMMIT;
2590: END IF;
2591: -- Debug info