APPS.HZ_WORD_REPLACEMENT_PUB dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.initialize;

94: END IF;
95:
96: --Initialize message list if p_init_msg_list is set to TRUE.
97: IF FND_API.to_Boolean(p_init_msg_list) THEN
98: FND_MSG_PUB.initialize;
99: END IF;
100:
101: --Initialize API return status to success.
102: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 117: FND_MSG_PUB.Count_And_Get(

113: commit;
114: END IF;
115:
116: --Standard call to get message count and if count is 1, get message info.
117: FND_MSG_PUB.Count_And_Get(
118: p_encoded => FND_API.G_FALSE,
119: p_count => x_msg_count,
120: p_data => x_msg_data);
121:

Line 126: FND_MSG_PUB.Count_And_Get(

122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO create_word_replacement_pub;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MSG_PUB.Count_And_Get(
127: p_encoded => FND_API.G_FALSE,
128: p_count => x_msg_count,
129: p_data => x_msg_data);
130:

Line 134: FND_MSG_PUB.Count_And_Get(

130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO create_word_replacement_pub;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MSG_PUB.Count_And_Get(
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data);
138:

Line 145: FND_MSG_PUB.ADD;

141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142:
143: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
144: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
145: FND_MSG_PUB.ADD;
146:
147: FND_MSG_PUB.Count_And_Get(
148: p_encoded => FND_API.G_FALSE,
149: p_count => x_msg_count,

Line 147: FND_MSG_PUB.Count_And_Get(

143: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
144: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
145: FND_MSG_PUB.ADD;
146:
147: FND_MSG_PUB.Count_And_Get(
148: p_encoded => FND_API.G_FALSE,
149: p_count => x_msg_count,
150: p_data => x_msg_data);
151:

Line 218: FND_MSG_PUB.initialize;

214: END IF;
215:
216: --Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean(p_init_msg_list) THEN
218: FND_MSG_PUB.initialize;
219: END IF;
220:
221: --Initialize API return status to success.
222: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 242: FND_MSG_PUB.Count_And_Get(

238: commit;
239: END IF;
240:
241: --Standard call to get message count and if count is 1, get message info.
242: FND_MSG_PUB.Count_And_Get(
243: p_encoded => FND_API.G_FALSE,
244: p_count => x_msg_count,
245: p_data => x_msg_data);
246:

Line 251: FND_MSG_PUB.Count_And_Get(

247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: ROLLBACK TO update_word_replacement_pub;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: FND_MSG_PUB.Count_And_Get(
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:

Line 259: FND_MSG_PUB.Count_And_Get(

255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: ROLLBACK TO update_word_replacement_pub;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: FND_MSG_PUB.Count_And_Get(
260: p_encoded => FND_API.G_FALSE,
261: p_count => x_msg_count,
262: p_data => x_msg_data);
263:

Line 270: FND_MSG_PUB.ADD;

266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
270: FND_MSG_PUB.ADD;
271:
272: FND_MSG_PUB.Count_And_Get(
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,

Line 272: FND_MSG_PUB.Count_And_Get(

268: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
270: FND_MSG_PUB.ADD;
271:
272: FND_MSG_PUB.Count_And_Get(
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data);
276:

Line 397: FND_MSG_PUB.ADD;

393: p_last_update_date = FND_API.G_MISS_DATE THEN
394:
395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
396: FND_MESSAGE.SET_TOKEN('COLUMN', 'word replacement last update date');
397: FND_MSG_PUB.ADD;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401:

Line 505: FND_MSG_PUB.ADD;

501: p_word_replacement_rec.original_word IS NULL)) OR (create_update_flag = 'U' AND
502: p_word_replacement_rec.original_word IS NULL) THEN
503: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
504: FND_MESSAGE.SET_TOKEN('COLUMN', 'original_word');
505: FND_MSG_PUB.ADD;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: END IF;
508:
509: IF (create_update_flag = 'C' AND (p_word_replacement_rec.type = FND_API.G_MISS_CHAR OR

Line 514: FND_MSG_PUB.ADD;

510: p_word_replacement_rec.type IS NULL)) OR (create_update_flag = 'U' AND
511: p_word_replacement_rec.type IS NULL) THEN
512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
513: FND_MESSAGE.SET_TOKEN('COLUMN', 'type');
514: FND_MSG_PUB.ADD;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: END IF;
517:
518:

Line 529: FND_MSG_PUB.ADD;

525: IF l_count = 0 THEN
526: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
527: FND_MESSAGE.SET_TOKEN('COLUMN', 'type');
528: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', 'HZ_WORD_REPLACEMENT_TYPE');
529: FND_MSG_PUB.ADD;
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: END IF;
532:
533:

Line 546: FND_MSG_PUB.ADD;

542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
543: FND_MESSAGE.SET_TOKEN('FK', 'country_code');
544: FND_MESSAGE.SET_TOKEN('COLUMN', 'territory_code');
545: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_territories');
546: FND_MSG_PUB.ADD;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;
550:

Line 558: fnd_msg_pub.add;

554: open c_dup_rec (p_word_replacement_rec.original_word, p_word_replacement_rec.type);
555: fetch c_dup_rec into l_dup_rec;
556: if c_dup_rec%FOUND then
557: fnd_message.set_name ('AR', 'HZ_MATCHING_RULE_EXISTS');
558: fnd_msg_pub.add;
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: end if;
561: END IF;
562: END;