DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_UNAVL_PVT dependencies on STANDARD

Line 694: -- Standard call to check for call compatibility.

690: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
691: l_return_status VARCHAR2(1);
692: l_space_restriction_rec space_restriction_rec;
693: BEGIN
694: -- Standard call to check for call compatibility.
695: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version,
696: p_api_version,
697: l_api_name,
698: G_PKG_NAME)

Line 847: -- Standard Start of API savepoint

843: l_space_restriction_rec Space_Restriction_Rec;
844:
845: BEGIN
846: --------------------Initialize ----------------------------------
847: -- Standard Start of API savepoint
848: SAVEPOINT create_space_restriction;
849: -- Check if API is called in debug mode. If yes, enable debug.
850: IF G_DEBUG='Y' THEN
851: AHL_DEBUG_PUB.enable_debug;

Line 857: -- Standard call to check for call compatibility.

853: -- Debug info.
854: IF G_DEBUG='Y' THEN
855: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_unavl_pvt.Create Space Restriction','+SUAVL+');
856: END IF;
857: -- Standard call to check for call compatibility.
858: IF FND_API.to_boolean(p_init_msg_list)
859: THEN
860: FND_MSG_PUB.initialize;
861: END IF;

Line 962: --Standard check to count messages

958: IF G_DEBUG='Y' THEN
959: AHL_DEBUG_PUB.debug( 'Space id'||p_x_space_restriction_rec.space_id);
960: END IF;
961:
962: --Standard check to count messages
963: l_msg_count := Fnd_Msg_Pub.count_msg;
964:
965: IF l_msg_count > 0 THEN
966: X_msg_count := l_msg_count;

Line 1143: --Standard check to count messages

1139: Fnd_Message.SET_NAME('AHL','AHL_LTP_RECORD_EXISTS');
1140: Fnd_Msg_Pub.ADD;
1141: END IF;
1142:
1143: --Standard check to count messages
1144: l_msg_count := Fnd_Msg_Pub.count_msg;
1145:
1146: IF l_msg_count > 0 THEN
1147: X_msg_count := l_msg_count;

Line 1186: --Standard check to count messages

1182: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1183:
1184: p_x_space_restriction_rec.space_unavailability_id := l_space_unavaialability_id;
1185: ---------------------------End of Body---------------------------------------
1186: --Standard check to count messages
1187: l_msg_count := Fnd_Msg_Pub.count_msg;
1188:
1189: IF l_msg_count > 0 THEN
1190: X_msg_count := l_msg_count;

Line 1195: --Standard check for commit

1191: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1192: RAISE Fnd_Api.G_EXC_ERROR;
1193: END IF;
1194:
1195: --Standard check for commit
1196: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1197: COMMIT;
1198: END IF;
1199: -- Debug info

Line 1330: -- Standard Start of API savepoint

1326: BEGIN
1327:
1328:
1329: --------------------Initialize ----------------------------------
1330: -- Standard Start of API savepoint
1331: SAVEPOINT update_space_restriction;
1332: -- Check if API is called in debug mode. If yes, enable debug.
1333: IF G_DEBUG='Y' THEN
1334: AHL_DEBUG_PUB.enable_debug;

Line 1338: -- Standard call to check for call compatibility.

1334: AHL_DEBUG_PUB.enable_debug;
1335: -- Debug info.
1336: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_unavl_pvt.Update Space Restriction','+SUAVL+');
1337: END IF;
1338: -- Standard call to check for call compatibility.
1339: IF FND_API.to_boolean(p_init_msg_list)
1340: THEN
1341: FND_MSG_PUB.initialize;
1342: END IF;

Line 1430: --Standard check to count messages

1426: Fnd_Message.SET_NAME('AHL','AHL_LTP_RECORD_EXISTS');
1427: Fnd_Msg_Pub.ADD;
1428: END IF;
1429: END IF;
1430: --Standard check to count messages
1431: l_msg_count := Fnd_Msg_Pub.count_msg;
1432:
1433: IF l_msg_count > 0 THEN
1434: X_msg_count := l_msg_count;

Line 1472: --Standard check to count messages

1468: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1469:
1470:
1471: ---------------------------End of Body---------------------------------------
1472: --Standard check to count messages
1473: l_msg_count := Fnd_Msg_Pub.count_msg;
1474:
1475: IF l_msg_count > 0 THEN
1476: X_msg_count := l_msg_count;

Line 1481: --Standard check for commit

1477: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1478: RAISE Fnd_Api.G_EXC_ERROR;
1479: END IF;
1480:
1481: --Standard check for commit
1482: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1483: COMMIT;
1484: END IF;
1485: IF G_DEBUG='Y' THEN

Line 1589: -- Standard Start of API savepoint

1585: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1586:
1587: BEGIN
1588: --------------------Initialize ----------------------------------
1589: -- Standard Start of API savepoint
1590: SAVEPOINT delete_space_restriction;
1591: -- Check if API is called in debug mode. If yes, enable debug.
1592: IF G_DEBUG='Y' THEN
1593: AHL_DEBUG_PUB.enable_debug;

Line 1599: -- Standard call to check for call compatibility.

1595: -- Debug info.
1596: IF G_DEBUG='Y' THEN
1597: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_unavl_pvt.Delete Space Restriction','+SUAVL+');
1598: END IF;
1599: -- Standard call to check for call compatibility.
1600: IF FND_API.to_boolean(p_init_msg_list)
1601: THEN
1602: FND_MSG_PUB.initialize;
1603: END IF;

Line 1639: --Standard check to count messages

1635: AHL_SPACE_UNAVAILABLE_PKG.DELETE_ROW (
1636: X_SPACE_UNAVAILABILITY_ID => l_space_unavailability_id
1637: );
1638: ---------------------------End of Body---------------------------------------
1639: --Standard check to count messages
1640: l_msg_count := Fnd_Msg_Pub.count_msg;
1641:
1642: IF l_msg_count > 0 THEN
1643: X_msg_count := l_msg_count;

Line 1648: --Standard check for commit

1644: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1645: RAISE Fnd_Api.G_EXC_ERROR;
1646: END IF;
1647:
1648: --Standard check for commit
1649: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1650: COMMIT;
1651: END IF;
1652: IF G_DEBUG='Y' THEN