401: ROLLBACK TO load_addresses_pvt;
402: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
403: FND_FILE.put_line(fnd_file.log, SQLERRM);
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
407: FND_MSG_PUB.ADD;
408: FND_MSG_PUB.Count_And_Get(
409: p_encoded => FND_API.G_FALSE,
402: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
403: FND_FILE.put_line(fnd_file.log, SQLERRM);
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
407: FND_MSG_PUB.ADD;
408: FND_MSG_PUB.Count_And_Get(
409: p_encoded => FND_API.G_FALSE,
410: p_count => x_msg_count,
435: ROLLBACK TO load_addresses_pvt;
436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
437: FND_FILE.put_line(fnd_file.log, SQLERRM);
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
440: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
441: FND_MSG_PUB.ADD;
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
437: FND_FILE.put_line(fnd_file.log, SQLERRM);
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
440: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
441: FND_MSG_PUB.ADD;
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
1190:
1191: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193:
1194: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1196: FND_MSG_PUB.ADD;
1197: when others then
1198: ----dbms_output.put_line('===================other exception');
1191: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193:
1194: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1196: FND_MSG_PUB.ADD;
1197: when others then
1198: ----dbms_output.put_line('===================other exception');
1199: ----dbms_output.put_line(sqlerrm);
1203:
1204: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206:
1207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1208: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1209: FND_MSG_PUB.ADD;
1210:
1211: end process_insert_addresses;
1204: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206:
1207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1208: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1209: FND_MSG_PUB.ADD;
1210:
1211: end process_insert_addresses;
1212:
3021:
3022: ROLLBACK to process_update_addresses_pvt;
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024:
3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3027: FND_MSG_PUB.ADD;
3028:
3029: end process_update_addresses;
3022: ROLLBACK to process_update_addresses_pvt;
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024:
3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3027: FND_MSG_PUB.ADD;
3028:
3029: end process_update_addresses;
3030: