DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_PARTY_SITE_USE_PKG dependencies on FND_MESSAGE

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

411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses dup val exception: ' || SQLERRM);
412: ROLLBACK to process_insert_psu_pvt;
413: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(
419: p_encoded => FND_API.G_FALSE,

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

412: ROLLBACK to process_insert_psu_pvt;
413: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(
419: p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,

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

424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses other exception: ' || SQLERRM);
425: ROLLBACK TO process_insert_psu_pvt;
426: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_encoded => FND_API.G_FALSE,

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

425: ROLLBACK TO process_insert_psu_pvt;
426: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count,

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

496: ROLLBACK TO load_partysiteuses_pvt;
497: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
498: FND_FILE.put_line(fnd_file.log, l_errm);
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,

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

497: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
498: FND_FILE.put_line(fnd_file.log, l_errm);
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,

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

518: ROLLBACK TO load_partysiteuses_pvt;
519: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
520: FND_FILE.put_line(fnd_file.log, l_errm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(
526: p_encoded => FND_API.G_FALSE,

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

519: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
520: FND_FILE.put_line(fnd_file.log, l_errm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(
526: p_encoded => FND_API.G_FALSE,
527: p_count => x_msg_count,