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_MSG_PUB

Line 24: FND_MSG_PUB.initialize;

20: BEGIN
21:
22: --Initialize message list if p_init_msg_list is set to TRUE.
23: IF FND_API.To_Boolean(p_init_msg_list) THEN
24: FND_MSG_PUB.initialize;
25: END IF;
26:
27: --Initialize API return status to success.
28: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 38: FND_MSG_PUB.ADD;

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

Line 80: FND_MSG_PUB.Count_And_Get(

76: x_orig_sys_entity_map_rec.orig_system := l_orig_system;
77: x_orig_sys_entity_map_rec.owner_table_name := l_owner_table_name;
78:
79: --Standard call to get message count and if count is 1, get message info.
80: FND_MSG_PUB.Count_And_Get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data );
84:

Line 89: FND_MSG_PUB.Count_And_Get(

85: EXCEPTION
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88:
89: FND_MSG_PUB.Count_And_Get(
90: p_encoded => FND_API.G_FALSE,
91: p_count => x_msg_count,
92: p_data => x_msg_data );
93:

Line 97: FND_MSG_PUB.Count_And_Get(

93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96:
97: FND_MSG_PUB.Count_And_Get(
98: p_encoded => FND_API.G_FALSE,
99: p_count => x_msg_count,
100: p_data => x_msg_data );
101:

Line 107: FND_MSG_PUB.ADD;

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

Line 109: FND_MSG_PUB.Count_And_Get(

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,
111: p_count => x_msg_count,
112: p_data => x_msg_data );
113:

Line 130: FND_MSG_PUB.initialize;

126: BEGIN
127:
128: --Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.To_Boolean(p_init_msg_list) THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: --Initialize API return status to success.
134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 142: FND_MSG_PUB.ADD;

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:
146: HZ_ORIG_SYSTEM_REF_PKG.Select_Row (

Line 185: FND_MSG_PUB.Count_And_Get(

181: x_attribute19 => x_orig_sys_reference_rec.attribute19,
182: x_attribute20 => x_orig_sys_reference_rec.attribute20
183: );
184: --Standard call to get message count and if count is 1, get message info.
185: FND_MSG_PUB.Count_And_Get(
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,
188: p_data => x_msg_data );
189:

Line 194: FND_MSG_PUB.Count_And_Get(

190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
194: FND_MSG_PUB.Count_And_Get(
195: p_encoded => FND_API.G_FALSE,
196: p_count => x_msg_count,
197: p_data => x_msg_data );
198:

Line 202: FND_MSG_PUB.Count_And_Get(

198:
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201:
202: FND_MSG_PUB.Count_And_Get(
203: p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data );
206:

Line 212: FND_MSG_PUB.ADD;

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

Line 214: FND_MSG_PUB.Count_And_Get(

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,
216: p_count => x_msg_count,
217: p_data => x_msg_data );
218:

Line 237: FND_MSG_PUB.initialize;

233: SAVEPOINT create_orig_sys_reference;
234:
235: -- initialize message list if p_init_msg_list is set to TRUE.
236: IF FND_API.to_Boolean(p_init_msg_list) THEN
237: FND_MSG_PUB.initialize;
238: END IF;
239:
240: -- initialize API return status to success.
241: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 251: FND_MSG_PUB.Count_And_Get(

247: x_return_status,
248: x_msg_count,
249: x_msg_data);
250: -- standard call to get message count and if count is 1, get message info.
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 260: FND_MSG_PUB.Count_And_Get(

256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO create_orig_sys_reference;
259: x_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 268: FND_MSG_PUB.Count_And_Get(

264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO create_orig_sys_reference;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.Count_And_Get(
269: p_encoded => FND_API.G_FALSE,
270: p_count => x_msg_count,
271: p_data => x_msg_data);
272:

Line 278: FND_MSG_PUB.ADD;

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,
282: p_data => x_msg_data);

Line 279: FND_MSG_PUB.Count_And_Get(

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,
282: p_data => x_msg_data);
283:

Line 304: FND_MSG_PUB.initialize;

300: SAVEPOINT update_orig_sys_reference;
301:
302: -- initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean(p_init_msg_list) THEN
304: FND_MSG_PUB.initialize;
305: END IF;
306:
307: -- initialize API return status to success.
308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 320: FND_MSG_PUB.Count_And_Get(

316: x_msg_count,
317: x_msg_data);
318:
319: -- standard call to get message count and if count is 1, get message info.
320: FND_MSG_PUB.Count_And_Get(
321: p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:

Line 329: FND_MSG_PUB.Count_And_Get(

325: EXCEPTION
326: WHEN FND_API.G_EXC_ERROR THEN
327: ROLLBACK TO update_orig_sys_reference;
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get(
330: p_encoded => FND_API.G_FALSE,
331: p_count => x_msg_count,
332: p_data => x_msg_data);
333:

Line 337: FND_MSG_PUB.Count_And_Get(

333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO update_orig_sys_reference;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: FND_MSG_PUB.Count_And_Get(
338: p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data);
341:

Line 347: FND_MSG_PUB.ADD;

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,
351: p_data => x_msg_data);

Line 348: FND_MSG_PUB.Count_And_Get(

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,
351: p_data => x_msg_data);
352:

Line 382: FND_MSG_PUB.Count_And_Get(

378: p_reason_code => p_reason_code,
379: x_return_status => x_return_status,
380: x_msg_count =>x_msg_count,
381: x_msg_data =>x_msg_data);
382: FND_MSG_PUB.Count_And_Get(
383: p_encoded => FND_API.G_FALSE,
384: p_count => x_msg_count,
385: p_data => x_msg_data );
386:

Line 391: FND_MSG_PUB.Count_And_Get(

387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: x_return_status := FND_API.G_RET_STS_ERROR;
390:
391: FND_MSG_PUB.Count_And_Get(
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data );
395:

Line 399: FND_MSG_PUB.Count_And_Get(

395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398:
399: FND_MSG_PUB.Count_And_Get(
400: p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data );
403:

Line 409: FND_MSG_PUB.ADD;

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

Line 411: FND_MSG_PUB.Count_And_Get(

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,
413: p_count => x_msg_count,
414: p_data => x_msg_data );
415:

Line 442: FND_MSG_PUB.ADD;

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
446: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

Line 449: FND_MSG_PUB.ADD;

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
453: open get_owner_table_id_csr;