DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on FND_MESSAGE

Line 212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');

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(

Line 213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');

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,

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

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(

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

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,

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

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(

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

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,

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

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(

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

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,

Line 1241: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

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

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;