133: CLOSE cu_contact_point_version;
134: END IF;
135:
136: IF x_rowid IS NULL THEN
137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_ERROR;
134: END IF;
135:
136: IF x_rowid IS NULL THEN
137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: ELSE
135:
136: IF x_rowid IS NULL THEN
137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: ELSE
143: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
142: ELSE
143: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
144: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
145: THEN
146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
147: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;
143: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
144: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
145: THEN
146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
147: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;
151: END IF;
225: and ( (p_phone_id is null)
226: or cont_point.contact_point_id <> p_phone_id );
227: --
228: if ( primary_count >= 1 ) then
229: fnd_message.set_name('AR','AR_CUST_ONE_PRIMARY_PHONE');
230: app_exception.raise_exception;
231: end if;
232: --
233: elsif (p_type = 'ADDR' ) then
246: and ( (p_phone_id is null)
247: or cont_point.contact_point_id <> p_phone_id );
248: --
249: if ( primary_count >= 1 ) then
250: fnd_message.set_name('AR','AR_CUST_ADDR_ONE_PRIMARY_PHONE');
251: app_exception.raise_exception;
252: end if;
253: elsif (p_type = 'CONT' ) then
254: --
265: and ( (p_phone_id is null)
266: or cont_point.contact_point_id <> p_phone_id );
267: --
268: if ( primary_count >= 1 ) then
269: fnd_message.set_name('AR','AR_CUST_CONT_ONE_PRIMARY_PHONE');
270: app_exception.raise_exception;
271: end if;
272: else
273: app_exception.invalid_argument('arp_phones_pkg.check_primary','p_type',p_type);