208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:
216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:
216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,
252: WHEN OTHERS THEN
253: ROLLBACK;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255:
256: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
257: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
258: FND_MSG_PUB.ADD;
259:
260: FND_MSG_PUB.Count_And_Get(
253: ROLLBACK;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255:
256: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
257: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
258: FND_MSG_PUB.ADD;
259:
260: FND_MSG_PUB.Count_And_Get(
261: p_encoded => FND_API.G_FALSE,
524: WHEN OTHERS THEN
525: ROLLBACK to check_single_party_trans;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527:
528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
530: FND_MSG_PUB.ADD;
531:
532: FND_MSG_PUB.Count_And_Get(
525: ROLLBACK to check_single_party_trans;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527:
528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
530: FND_MSG_PUB.ADD;
531:
532: FND_MSG_PUB.Count_And_Get(
533: p_encoded => FND_API.G_FALSE,
1136: WHEN OTHERS THEN
1137: ROLLBACK to PURGE_PARTY;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139:
1140: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1141: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1142: FND_MSG_PUB.ADD;
1143:
1144: FND_MSG_PUB.Count_And_Get(
1137: ROLLBACK to PURGE_PARTY;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139:
1140: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1141: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1142: FND_MSG_PUB.ADD;
1143:
1144: FND_MSG_PUB.Count_And_Get(
1145: p_encoded => FND_API.G_FALSE,
1237:
1238: RETURN ret_data_type;
1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;*/
1245: null;
1238: RETURN ret_data_type;
1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;*/
1245: null;
1246: END get_col_type;