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
185: (p_count=>x_msg_count,
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
185: (p_count=>x_msg_count,
186: p_data=>x_msg_data
187: );
188: END SYNC_Supplier;
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
476: (p_count=>x_msg_count,
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
476: (p_count=>x_msg_count,
477: p_data=>x_msg_data
478: );
479: