23: region_code = X_REGION_CODE)
24: and ((X_ROWID is null) or (rowid <> X_ROWID));
25:
26: if (dummy >= 1) then
27: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
28: app_exception.raise_exception;
29: end if;
30: EXCEPTION
31: WHEN OTHERS THEN
29: end if;
30: EXCEPTION
31: WHEN OTHERS THEN
32: IF (SQLCODE <> -20001) THEN
33: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
34: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
35: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
37: ', REGION_SHORT_NAME = ' || X_REGION_SHORT_NAME ||
30: EXCEPTION
31: WHEN OTHERS THEN
32: IF (SQLCODE <> -20001) THEN
33: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
34: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
35: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
37: ', REGION_SHORT_NAME = ' || X_REGION_SHORT_NAME ||
38: ', REGION_CODE = ' || X_REGION_CODE);
31: WHEN OTHERS THEN
32: IF (SQLCODE <> -20001) THEN
33: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
34: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
35: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
37: ', REGION_SHORT_NAME = ' || X_REGION_SHORT_NAME ||
38: ', REGION_CODE = ' || X_REGION_CODE);
39: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
32: IF (SQLCODE <> -20001) THEN
33: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
34: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
35: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
37: ', REGION_SHORT_NAME = ' || X_REGION_SHORT_NAME ||
38: ', REGION_CODE = ' || X_REGION_CODE);
39: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
40: END IF;
35: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_ROWID ||
37: ', REGION_SHORT_NAME = ' || X_REGION_SHORT_NAME ||
38: ', REGION_CODE = ' || X_REGION_CODE);
39: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
40: END IF;
41: APP_EXCEPTION.RAISE_EXCEPTION;
42:
43: end CHECK_UNIQUE;