346: END IF;
347:
348: savepoint process_insert_psu_pvt;
349:
350: FND_MSG_PUB.initialize;
351:
352: --Initialize API return status to success.
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:
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,
421: p_data => x_msg_data);
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,
421: p_data => x_msg_data);
422:
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,
434: p_data => x_msg_data);
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,
434: p_data => x_msg_data);
435:
460: p_prefix=>l_debug_prefix,
461: p_msg_level=>fnd_log.level_procedure);
462: END IF;
463:
464: FND_MSG_PUB.initialize;
465:
466: --Initialize API return status to success.
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO load_partysiteuses_pvt;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MSG_PUB.Count_And_Get(
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data);
494:
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,
506: p_data => x_msg_data);
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,
506: p_data => x_msg_data);
507:
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,
528: p_data => x_msg_data);
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,
528: p_data => x_msg_data);
529: