174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: IF (SQLCODE <> -20001) THEN
178: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
180: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
181: FND_MSG_PUB.Add;
182: END IF;
175: EXCEPTION
176: WHEN OTHERS THEN
177: IF (SQLCODE <> -20001) THEN
178: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
180: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
181: FND_MSG_PUB.Add;
182: END IF;
183: x_return_status := fnd_api.g_ret_sts_error;
176: WHEN OTHERS THEN
177: IF (SQLCODE <> -20001) THEN
178: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
179: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
180: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
181: FND_MSG_PUB.Add;
182: END IF;
183: x_return_status := fnd_api.g_ret_sts_error;
184: FND_MSG_PUB.Count_And_Get
464: EXCEPTION
465:
466: WHEN OTHERS THEN
467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;
465:
466: WHEN OTHERS THEN
467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;
473: END IF;
466: WHEN OTHERS THEN
467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;
473: END IF;
474: x_return_status := fnd_api.g_ret_sts_error;
467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;
473: END IF;
474: x_return_status := fnd_api.g_ret_sts_error;
475: FND_MSG_PUB.Count_And_Get