eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_WORD_REPLACEMENT_PUB dependencies on FND_MESSAGE

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

139: WHEN OTHERS THEN
140: ROLLBACK TO create_word_replacement_pub;
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(

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

140: ROLLBACK TO create_word_replacement_pub;
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,

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

264: WHEN OTHERS THEN
265: ROLLBACK TO update_word_replacement_pub;
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(

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

265: ROLLBACK TO update_word_replacement_pub;
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,

Line 395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

391: --Check whether last_update_date has been passed in.
392: IF p_last_update_date IS NULL OR
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;

Line 396: FND_MESSAGE.SET_TOKEN('COLUMN', 'word replacement last update date');

392: IF p_last_update_date IS NULL OR
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:

Line 503: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

499: --Check for mandatory, but updateable columns
500: IF (create_update_flag = 'C' AND (p_word_replacement_rec.original_word = FND_API.G_MISS_CHAR OR
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;

Line 504: FND_MESSAGE.SET_TOKEN('COLUMN', 'original_word');

500: IF (create_update_flag = 'C' AND (p_word_replacement_rec.original_word = FND_API.G_MISS_CHAR OR
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:

Line 512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

508:
509: IF (create_update_flag = 'C' AND (p_word_replacement_rec.type = FND_API.G_MISS_CHAR OR
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;

Line 513: FND_MESSAGE.SET_TOKEN('COLUMN', 'type');

509: IF (create_update_flag = 'C' AND (p_word_replacement_rec.type = FND_API.G_MISS_CHAR OR
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:

Line 526: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');

522: WHERE lookup_type = 'HZ_WORD_REPLACEMENT_TYPE'
523: AND lookup_code = p_word_replacement_rec.type;
524:
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;

Line 527: FND_MESSAGE.SET_TOKEN('COLUMN', 'type');

523: AND lookup_code = p_word_replacement_rec.type;
524:
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;

Line 528: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', 'HZ_WORD_REPLACEMENT_TYPE');

524:
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:

Line 542: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

538: FROM fnd_territories
539: WHERE territory_code = p_word_replacement_rec.country_code;
540:
541: IF l_count = 0 THEN
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;

Line 543: FND_MESSAGE.SET_TOKEN('FK', 'country_code');

539: WHERE territory_code = p_word_replacement_rec.country_code;
540:
541: IF l_count = 0 THEN
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;

Line 544: FND_MESSAGE.SET_TOKEN('COLUMN', 'territory_code');

540:
541: IF l_count = 0 THEN
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;

Line 545: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_territories');

541: IF l_count = 0 THEN
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;

Line 557: fnd_message.set_name ('AR', 'HZ_MATCHING_RULE_EXISTS');

553: THEN
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;