DBA Data[Home] [Help]

APPS.ARH_CONT_PKG dependencies on FND_MESSAGE

Line 212: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');

208:
209: END IF;
210:
211: IF x_rowid IS NULL THEN
212: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
213: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
214: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;

Line 213: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);

209: END IF;
210:
211: IF x_rowid IS NULL THEN
212: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
213: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
214: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: ELSE

Line 214: FND_MESSAGE.SET_TOKEN('ID',p_col_id);

210:
211: IF x_rowid IS NULL THEN
212: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
213: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
214: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: ELSE
218: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>

Line 221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

217: ELSE
218: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
219: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
220: THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
222: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
223: FND_MSG_PUB.ADD;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END IF;

Line 222: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);

218: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
219: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
220: THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
222: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
223: FND_MSG_PUB.ADD;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: END IF;
226: END IF;

Line 250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');

246: UPDATE hz_org_contacts
247: SET mail_stop = p_mail_stop
248: WHERE org_contact_id = p_org_contact_id;
249: ELSE
250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');
252: FND_MESSAGE.SET_TOKEN('ID',p_org_contact_id);
253: FND_MSG_PUB.ADD;
254: x_return_status := FND_API.G_RET_STS_ERROR;

Line 251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');

247: SET mail_stop = p_mail_stop
248: WHERE org_contact_id = p_org_contact_id;
249: ELSE
250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');
252: FND_MESSAGE.SET_TOKEN('ID',p_org_contact_id);
253: FND_MSG_PUB.ADD;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: END IF;

Line 252: FND_MESSAGE.SET_TOKEN('ID',p_org_contact_id);

248: WHERE org_contact_id = p_org_contact_id;
249: ELSE
250: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
251: FND_MESSAGE.SET_TOKEN('RECORD','HZ_ORG_CONTACTS');
252: FND_MESSAGE.SET_TOKEN('ID',p_org_contact_id);
253: FND_MSG_PUB.ADD;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: END IF;
256: CLOSE cu_org_contact_update;

Line 262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

258: WHEN OTHERS THEN
259: IF cu_org_contact_update%ISOPEN THEN
260: CLOSE cu_org_contact_update;
261: END IF;
262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
263: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
264: FND_MSG_PUB.ADD;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: END;

Line 263: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

259: IF cu_org_contact_update%ISOPEN THEN
260: CLOSE cu_org_contact_update;
261: END IF;
262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
263: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
264: FND_MSG_PUB.ADD;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: END;
267:

Line 295: fnd_message.set_name ('AR','AR_CUST_DUP_CONTACT_NAME');

291: and rel.directional_flag = 'F'
292: );
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: fnd_message.set_name ('AR','AR_CUST_DUP_CONTACT_NAME');
296: x_warning_flag := 'W';
297: END check_unique_contact_name;
298: --
299: --

Line 340: fnd_message.set_name ('AR','AR_CUST_CONT_REF_EXISTS');

336: = x_orig_system_reference
337: );
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: fnd_message.set_name ('AR','AR_CUST_CONT_REF_EXISTS');
341: app_exception.raise_exception;
342: --
343: END check_unique_orig_system_ref;
344: