DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CONTACT_ROLE_PKG dependencies on FND_MESSAGE

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

426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contactroles dup val exception: ' || SQLERRM);
427: ROLLBACK to load_contactroles_pvt;
428: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
432: FND_MSG_PUB.ADD;
433: FND_MSG_PUB.Count_And_Get(
434: p_encoded => FND_API.G_FALSE,

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

427: ROLLBACK to load_contactroles_pvt;
428: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
432: FND_MSG_PUB.ADD;
433: FND_MSG_PUB.Count_And_Get(
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,

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

439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contactroles other exception: ' || SQLERRM);
440: ROLLBACK TO load_contactroles_pvt;
441: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.Count_And_Get(
447: p_encoded => FND_API.G_FALSE,

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

440: ROLLBACK TO load_contactroles_pvt;
441: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.Count_And_Get(
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,

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

510: ROLLBACK TO load_contactroles_pvt;
511: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
512: FND_FILE.put_line(fnd_file.log, l_errm);
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
516: FND_MSG_PUB.ADD;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,

Line 515: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);

511: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
512: FND_FILE.put_line(fnd_file.log, l_errm);
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
516: FND_MSG_PUB.ADD;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,

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

523: ROLLBACK TO load_contactroles_pvt;
524: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
525: FND_FILE.put_line(fnd_file.log, l_errm);
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
529: FND_MSG_PUB.ADD;
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_FALSE,

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

524: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
525: FND_FILE.put_line(fnd_file.log, l_errm);
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
529: FND_MSG_PUB.ADD;
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,