[Home] [Help]
668: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
669: l_return_status VARCHAR2(1);
670: l_space_rec space_rec;
671: BEGIN
672: -- Standard call to check for call compatibility.
673: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version,
674: p_api_version,
675: l_api_name,
676: G_PKG_NAME)
806: WHERE space_id = x_id);
807: --
808: BEGIN
809: --------------------Initialize ----------------------------------
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;
816: -- Debug info.
817: IF G_DEBUG='Y' THEN
818: AHL_DEBUG_PUB.debug( 'enter ahl_appr_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
823: FND_MSG_PUB.initialize;
824: END IF;
930: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_NOT_EXIST');
931: Fnd_Msg_Pub.ADD;
932: END IF;
933:
934: --Standard check to count messages
935: l_msg_count := Fnd_Msg_Pub.count_msg;
936:
937: IF l_msg_count > 0 THEN
938: X_msg_count := l_msg_count;
1100: l_space_rec.attribute15 := p_x_space_rec.attribute15;
1101: END IF;
1102: END IF;
1103:
1104: --Standard check to count messages
1105: l_msg_count := Fnd_Msg_Pub.count_msg;
1106:
1107: IF l_msg_count > 0 THEN
1108: X_msg_count := l_msg_count;
1144: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1145:
1146: p_x_space_rec.space_id := l_space_id;
1147: ---------------------------End of Body---------------------------------------
1148: --Standard check to count messages
1149: l_msg_count := Fnd_Msg_Pub.count_msg;
1150:
1151: IF l_msg_count > 0 THEN
1152: X_msg_count := l_msg_count;
1153: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1154: RAISE Fnd_Api.G_EXC_ERROR;
1155: END IF;
1156:
1157: --Standard check for commit
1158: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1159: COMMIT;
1160: END IF;
1161: -- Debug info
1265: BEGIN
1266:
1267:
1268: --------------------Initialize ----------------------------------
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;
1275: -- Debug info.
1276: IF G_DEBUG='Y' THEN
1277: AHL_DEBUG_PUB.debug( 'enter ahl_appr_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
1282: FND_MSG_PUB.initialize;
1283: END IF;
1409: x_return_status => l_return_status,
1410: x_msg_count => l_msg_count,
1411: x_msg_data => l_msg_data );
1412:
1413: --Standard check to count messages
1414: l_msg_count := Fnd_Msg_Pub.count_msg;
1415:
1416: IF l_msg_count > 0 THEN
1417: X_msg_count := l_msg_count;
1454: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1455:
1456:
1457: ---------------------------End of Body---------------------------------------
1458: --Standard check to count messages
1459: l_msg_count := Fnd_Msg_Pub.count_msg;
1460:
1461: IF l_msg_count > 0 THEN
1462: X_msg_count := l_msg_count;
1463: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1464: RAISE Fnd_Api.G_EXC_ERROR;
1465: END IF;
1466:
1467: --Standard check for commit
1468: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1469: COMMIT;
1470: END IF;
1471: -- Debug info
1584: l_visit_id NUMBER;
1585: --
1586: BEGIN
1587: --------------------Initialize ----------------------------------
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;
1594: -- Debug info.
1595: IF G_DEBUG='Y' THEN
1596: AHL_DEBUG_PUB.debug( 'enter ahl_appr_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
1601: FND_MSG_PUB.initialize;
1602: END IF;
1653: END IF;
1654: END LOOP;
1655: CLOSE c_space_visit_cur;
1656: --
1657: --Standard check to count messages
1658: l_msg_count := Fnd_Msg_Pub.count_msg;
1659:
1660: IF l_msg_count > 0 THEN
1661: X_msg_count := l_msg_count;
1673: WHERE SPACE_ID = l_space_id;
1674:
1675: END IF;
1676: ---------------------------End of Body---------------------------------------
1677: --Standard check to count messages
1678: l_msg_count := Fnd_Msg_Pub.count_msg;
1679:
1680: IF l_msg_count > 0 THEN
1681: X_msg_count := l_msg_count;
1682: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1683: RAISE Fnd_Api.G_EXC_ERROR;
1684: END IF;
1685:
1686: --Standard check for commit
1687: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1688: COMMIT;
1689: END IF;
1690: -- Debug info
2191: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2192: l_return_status VARCHAR2(1);
2193: l_space_capblts_rec space_capbl_rec;
2194: BEGIN
2195: -- Standard call to check for call compatibility.
2196: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version,
2197: p_api_version,
2198: l_api_name,
2199: G_PKG_NAME)
2336:
2337: BEGIN
2338:
2339: --------------------Initialize ----------------------------------
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;
2346: -- Debug info.
2347: IF G_DEBUG='Y' THEN
2348: AHL_DEBUG_PUB.debug( 'enter ahl_appr_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
2353: FND_MSG_PUB.initialize;
2354: END IF;
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
2513: l_msg_count := Fnd_Msg_Pub.count_msg;
2514:
2515: IF l_msg_count > 0 THEN
2516: X_msg_count := l_msg_count;
2678: l_space_capblts_rec.attribute15 := p_x_space_capblts_rec.attribute15;
2679: END IF;
2680: END IF;
2681:
2682: --Standard check to count messages
2683: l_msg_count := Fnd_Msg_Pub.count_msg;
2684:
2685: IF l_msg_count > 0 THEN
2686: X_msg_count := l_msg_count;
2753: );
2754:
2755: p_x_space_capblts_rec.space_capability_id := l_space_capability_id;
2756: ---------------------------End of Body---------------------------------------
2757: --Standard check to count messages
2758: l_msg_count := Fnd_Msg_Pub.count_msg;
2759:
2760: IF l_msg_count > 0 THEN
2761: X_msg_count := l_msg_count;
2762: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2763: RAISE Fnd_Api.G_EXC_ERROR;
2764: END IF;
2765:
2766: --Standard check for commit
2767: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2768: COMMIT;
2769: END IF;
2770: -- Debug info
2875:
2876: BEGIN
2877:
2878: --------------------Initialize ----------------------------------
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;
2885: -- Debug info.
2886: IF G_DEBUG='Y' THEN
2887: AHL_DEBUG_PUB.debug( 'enter ahl_appr_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
2892: FND_MSG_PUB.initialize;
2893: END IF;
3078: WHERE space_capability_id = p_space_capblts_rec.space_capability_id;
3079:
3080:
3081: ---------------------------End of Body---------------------------------------
3082: --Standard check to count messages
3083: l_msg_count := Fnd_Msg_Pub.count_msg;
3084:
3085: IF l_msg_count > 0 THEN
3086: X_msg_count := l_msg_count;
3087: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3088: RAISE Fnd_Api.G_EXC_ERROR;
3089: END IF;
3090:
3091: --Standard check for commit
3092: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3093: COMMIT;
3094: END IF;
3095: -- Debug info
3219: l_inventory_item_id NUMBER;
3220: --
3221: BEGIN
3222: --------------------Initialize ----------------------------------
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;
3229: -- Debug info.
3230: IF G_DEBUG='Y' THEN
3231: AHL_DEBUG_PUB.debug( 'enter ahl_appr_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
3236: FND_MSG_PUB.initialize;
3237: END IF;
3295: DELETE FROM AHL_SPACE_CAPABILITIES
3296: WHERE SPACE_CAPABILITY_ID = l_space_capability_id;
3297:
3298: ---------------------------End of Body---------------------------------------
3299: --Standard check to count messages
3300: l_msg_count := Fnd_Msg_Pub.count_msg;
3301:
3302: IF l_msg_count > 0 THEN
3303: X_msg_count := l_msg_count;
3304: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3305: RAISE Fnd_Api.G_EXC_ERROR;
3306: END IF;
3307:
3308: --Standard check for commit
3309: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3310: COMMIT;
3311: END IF;
3312: -- Debug info