DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

58: SAVEPOINT generate_body;
59:
60: -- initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean(p_init_msg_list) THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- initialize API return status to success.
66: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');

87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');
91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');
92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');

Line 214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');

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,
218: p_count => x_msg_count,

Line 216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(

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,
218: p_count => x_msg_count,
219: p_data => x_msg_data );');
220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');

Line 229: FND_MSG_PUB.Count_And_Get(

225: HZ_GEN_PLSQL.compile_code;
226:
227:
228: -- standard call to get message count and if count is 1, get message info.
229: FND_MSG_PUB.Count_And_Get(
230: p_encoded => FND_API.G_FALSE,
231: p_count => x_msg_count,
232: p_data => x_msg_data);
233:

Line 238: FND_MSG_PUB.Count_And_Get(

234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: ROLLBACK ;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: FND_MSG_PUB.Count_And_Get(
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data);
242: RAISE FND_API.G_EXC_ERROR;

Line 247: FND_MSG_PUB.Count_And_Get(

243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK ;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 258: FND_MSG_PUB.ADD;

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,
262: p_count => x_msg_count,

Line 260: FND_MSG_PUB.Count_And_Get(

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,
262: p_count => x_msg_count,
263: p_data => x_msg_data );
264: RAISE FND_API.G_EXC_ERROR;

Line 481: FND_MSG_PUB.initialize;

477: SAVEPOINT check_single_party_trans;
478:
479: -- initialize message list if p_init_msg_list is set to TRUE.
480: IF FND_API.to_Boolean(p_init_msg_list) THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483:
484: -- initialize API return status to success.
485: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 500: FND_MSG_PUB.Count_And_Get(

496: end if;
497: close party;
498:
499: -- standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get(
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data);
504:

Line 509: FND_MSG_PUB.Count_And_Get(

505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO check_single_party_trans;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data);
513: RAISE FND_API.G_EXC_ERROR;

Line 518: FND_MSG_PUB.Count_And_Get(

514:
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO check_single_party_trans;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.Count_And_Get(
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data);
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 530: FND_MSG_PUB.ADD;

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,
534: p_count => x_msg_count,

Line 532: FND_MSG_PUB.Count_And_Get(

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,
534: p_count => x_msg_count,
535: p_data => x_msg_data );
536: RAISE FND_API.G_EXC_ERROR;

Line 915: FND_MSG_PUB.initialize;

911: SAVEPOINT PURGE_PARTY;
912:
913: -- initialize message list if p_init_msg_list is set to TRUE.
914: IF FND_API.to_Boolean(p_init_msg_list) THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: -- initialize API return status to success.
919: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1111: FND_MSG_PUB.Count_And_Get(

1107:
1108: --fnd_file.close;
1109: hz_common_pub.enable_cont_source_security;
1110: -- standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get(
1112: p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count,
1114: p_data => x_msg_data);
1115:

Line 1121: FND_MSG_PUB.Count_And_Get(

1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO PURGE_PARTY;
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: FND_MSG_PUB.Count_And_Get(
1122: p_encoded => FND_API.G_FALSE,
1123: p_count => x_msg_count,
1124: p_data => x_msg_data);
1125: RAISE FND_API.G_EXC_ERROR;

Line 1130: FND_MSG_PUB.Count_And_Get(

1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO PURGE_PARTY;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data);
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1142: FND_MSG_PUB.ADD;

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,
1146: p_count => x_msg_count,

Line 1144: FND_MSG_PUB.Count_And_Get(

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,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data );
1148: RAISE FND_API.G_EXC_ERROR;

Line 1180: FND_MSG_PUB.Reset;

1176:
1177: FUNCTION logerror RETURN VARCHAR2 IS
1178: l_msg_data VARCHAR2(2000);
1179: BEGIN
1180: FND_MSG_PUB.Reset;
1181:
1182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1183: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1184: END LOOP;

Line 1182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1178: l_msg_data VARCHAR2(2000);
1179: BEGIN
1180: FND_MSG_PUB.Reset;
1181:
1182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1183: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1184: END LOOP;
1185: log(l_msg_data,true);
1186: RETURN l_msg_data;

Line 1183: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

1179: BEGIN
1180: FND_MSG_PUB.Reset;
1181:
1182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1183: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1184: END LOOP;
1185: log(l_msg_data,true);
1186: RETURN l_msg_data;
1187: END logerror;

Line 1243: FND_MSG_PUB.ADD;

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;
1247: