170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: IF (SQLCODE <> -20001) THEN
174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
176: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
177: FND_MSG_PUB.Add;
178: END IF;
171: EXCEPTION
172: WHEN OTHERS THEN
173: IF (SQLCODE <> -20001) THEN
174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
176: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
177: FND_MSG_PUB.Add;
178: END IF;
179: x_return_status := fnd_api.g_ret_sts_error;
172: WHEN OTHERS THEN
173: IF (SQLCODE <> -20001) THEN
174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
176: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
177: FND_MSG_PUB.Add;
178: END IF;
179: x_return_status := fnd_api.g_ret_sts_error;
180: FND_MSG_PUB.Count_And_Get
428: EXCEPTION
429:
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;
429:
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;
437: END IF;
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;
437: END IF;
438: x_return_status := fnd_api.g_ret_sts_error;
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;
437: END IF;
438: x_return_status := fnd_api.g_ret_sts_error;
439: FND_MSG_PUB.Count_And_Get