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 903: FND_MSG_PUB.initialize;

899: SAVEPOINT PURGE_PARTY;
900:
901: -- initialize message list if p_init_msg_list is set to TRUE.
902: IF FND_API.to_Boolean(p_init_msg_list) THEN
903: FND_MSG_PUB.initialize;
904: END IF;
905:
906: -- initialize API return status to success.
907: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1094: FND_MSG_PUB.Count_And_Get(

1090:
1091: --fnd_file.close;
1092: hz_common_pub.enable_cont_source_security;
1093: -- standard call to get message count and if count is 1, get message info.
1094: FND_MSG_PUB.Count_And_Get(
1095: p_encoded => FND_API.G_FALSE,
1096: p_count => x_msg_count,
1097: p_data => x_msg_data);
1098:

Line 1104: FND_MSG_PUB.Count_And_Get(

1100: EXCEPTION
1101: WHEN FND_API.G_EXC_ERROR THEN
1102: ROLLBACK TO PURGE_PARTY;
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: FND_MSG_PUB.Count_And_Get(
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data);
1108: RAISE FND_API.G_EXC_ERROR;

Line 1113: FND_MSG_PUB.Count_And_Get(

1109:
1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1111: ROLLBACK TO PURGE_PARTY;
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1113: FND_MSG_PUB.Count_And_Get(
1114: p_encoded => FND_API.G_FALSE,
1115: p_count => x_msg_count,
1116: p_data => x_msg_data);
1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1125: FND_MSG_PUB.ADD;

1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1122:
1123: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1124: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1125: FND_MSG_PUB.ADD;
1126:
1127: FND_MSG_PUB.Count_And_Get(
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,

Line 1127: FND_MSG_PUB.Count_And_Get(

1123: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1124: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1125: FND_MSG_PUB.ADD;
1126:
1127: FND_MSG_PUB.Count_And_Get(
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data );
1131: RAISE FND_API.G_EXC_ERROR;

Line 1163: FND_MSG_PUB.Reset;

1159:
1160: FUNCTION logerror RETURN VARCHAR2 IS
1161: l_msg_data VARCHAR2(2000);
1162: BEGIN
1163: FND_MSG_PUB.Reset;
1164:
1165: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1166: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1167: END LOOP;

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

1161: l_msg_data VARCHAR2(2000);
1162: BEGIN
1163: FND_MSG_PUB.Reset;
1164:
1165: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1166: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1167: END LOOP;
1168: log(l_msg_data,true);
1169: RETURN l_msg_data;

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

1162: BEGIN
1163: FND_MSG_PUB.Reset;
1164:
1165: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1166: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1167: END LOOP;
1168: log(l_msg_data,true);
1169: RETURN l_msg_data;
1170: END logerror;

Line 1226: FND_MSG_PUB.ADD;

1222: EXCEPTION
1223: WHEN OTHERS THEN
1224: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1225: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1226: FND_MSG_PUB.ADD;
1227: RAISE FND_API.G_EXC_ERROR;*/
1228: null;
1229: END get_col_type;
1230: