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_ORIG_SYSTEM_REF_PUB dependencies on FND_MESSAGE

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

32: p_orig_system = FND_API.G_MISS_CHAR) and
33: (p_owner_table_name IS NULL OR
34: p_owner_table_name = FND_API.G_MISS_CHAR)
35: THEN
36: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
37: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+owner_table_name');
38: FND_MSG_PUB.ADD;
39: RAISE FND_API.G_EXC_ERROR;
40: END IF;

Line 37: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+owner_table_name');

33: (p_owner_table_name IS NULL OR
34: p_owner_table_name = FND_API.G_MISS_CHAR)
35: THEN
36: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
37: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+owner_table_name');
38: FND_MSG_PUB.ADD;
39: RAISE FND_API.G_EXC_ERROR;
40: END IF;
41:

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

101:
102: WHEN OTHERS THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104:
105: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
107: FND_MSG_PUB.ADD;
108:
109: FND_MSG_PUB.Count_And_Get(

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

102: WHEN OTHERS THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104:
105: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
107: FND_MSG_PUB.ADD;
108:
109: FND_MSG_PUB.Count_And_Get(
110: p_encoded => FND_API.G_FALSE,

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

136: --Check whether primary key has been passed in.
137: IF (p_orig_system_ref_id IS NULL OR
138: p_orig_system_ref_id = FND_API.G_MISS_NUM)
139: THEN
140: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
141: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system_ref_id');
142: FND_MSG_PUB.ADD;
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;

Line 141: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system_ref_id');

137: IF (p_orig_system_ref_id IS NULL OR
138: p_orig_system_ref_id = FND_API.G_MISS_NUM)
139: THEN
140: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
141: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system_ref_id');
142: FND_MSG_PUB.ADD;
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:

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

206:
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
211: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
212: FND_MSG_PUB.ADD;
213:
214: FND_MSG_PUB.Count_And_Get(

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

207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
211: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
212: FND_MSG_PUB.ADD;
213:
214: FND_MSG_PUB.Count_And_Get(
215: p_encoded => FND_API.G_FALSE,

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

272:
273: WHEN OTHERS THEN
274: ROLLBACK TO create_orig_sys_reference;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
277: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
278: FND_MSG_PUB.ADD;
279: FND_MSG_PUB.Count_And_Get(
280: p_encoded => FND_API.G_FALSE,

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

273: WHEN OTHERS THEN
274: ROLLBACK TO create_orig_sys_reference;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
277: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
278: FND_MSG_PUB.ADD;
279: FND_MSG_PUB.Count_And_Get(
280: p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,

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

341:
342: WHEN OTHERS THEN
343: ROLLBACK TO update_orig_sys_reference;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
347: FND_MSG_PUB.ADD;
348: FND_MSG_PUB.Count_And_Get(
349: p_encoded => FND_API.G_FALSE,

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

342: WHEN OTHERS THEN
343: ROLLBACK TO update_orig_sys_reference;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
347: FND_MSG_PUB.ADD;
348: FND_MSG_PUB.Count_And_Get(
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,

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

403:
404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
408: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
409: FND_MSG_PUB.ADD;
410:
411: FND_MSG_PUB.Count_And_Get(

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

404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
408: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
409: FND_MSG_PUB.ADD;
410:
411: FND_MSG_PUB.Count_And_Get(
412: p_encoded => FND_API.G_FALSE,

Line 440: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');

436: l_count :=hz_mosr_validate_pkg.get_orig_system_ref_count(p_orig_system,
437: p_orig_system_reference,p_owner_table_name);
438: if l_count > 1
439: then
440: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
441: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
442: FND_MSG_PUB.ADD;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: elsif l_count = 0

Line 441: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');

437: p_orig_system_reference,p_owner_table_name);
438: if l_count > 1
439: then
440: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
441: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
442: FND_MSG_PUB.ADD;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: elsif l_count = 0
445: then

Line 446: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

442: FND_MSG_PUB.ADD;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: elsif l_count = 0
445: then
446: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
447: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
448: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
449: FND_MSG_PUB.ADD;
450: x_return_status := FND_API.G_RET_STS_ERROR;

Line 447: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');

443: x_return_status := FND_API.G_RET_STS_ERROR;
444: elsif l_count = 0
445: then
446: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
447: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
448: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
449: FND_MSG_PUB.ADD;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: elsif l_count = 1

Line 448: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

444: elsif l_count = 0
445: then
446: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
447: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
448: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
449: FND_MSG_PUB.ADD;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: elsif l_count = 1
452: then