202: p_prefix=>l_debug_prefix,
203: p_msg_level=>fnd_log.level_procedure);
204: END IF;
205:
206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
207: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
208: FND_MSG_PUB.ADD;
209: RAISE FND_API.G_EXC_ERROR;
210: ELSE
203: p_msg_level=>fnd_log.level_procedure);
204: END IF;
205:
206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
207: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
208: FND_MSG_PUB.ADD;
209: RAISE FND_API.G_EXC_ERROR;
210: ELSE
211: l_count := 1;
394: OPEN C;
395: FETCH C INTO Recinfo;
396: IF ( C%NOTFOUND ) THEN
397: CLOSE C;
398: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
399: APP_EXCEPTION.RAISE_EXCEPTION;
400: END IF;
401: CLOSE C;
402:
538: AND ( X_GLOBAL_LOCATION_NUMBER IS NULL ) ) )
539: ) THEN
540: RETURN;
541: ELSE
542: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
543: APP_EXCEPTION.RAISE_EXCEPTION;
544: END IF;
545:
546: END Lock_Row;
667: WHERE PARTY_SITE_ID = X_PARTY_SITE_ID;
668:
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
671: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
672: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_site_rec');
673: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_SITE_ID ) );
674: FND_MSG_PUB.ADD;
675: RAISE FND_API.G_EXC_ERROR;
668:
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
671: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
672: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_site_rec');
673: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_SITE_ID ) );
674: FND_MSG_PUB.ADD;
675: RAISE FND_API.G_EXC_ERROR;
676:
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
671: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
672: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_site_rec');
673: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_SITE_ID ) );
674: FND_MSG_PUB.ADD;
675: RAISE FND_API.G_EXC_ERROR;
676:
677: END Select_Row;