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.FUN_PARTY_MERGE_PUB dependencies on FND_MESSAGE

Line 83: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');

79:
80: IF p_parent_entity_name = 'HZ_PARTIES' THEN
81:
82: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
83: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
84: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_BATCHES', FALSE);
85:
86: Open C1;
87: Close C1;

Line 84: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_BATCHES', FALSE);

80: IF p_parent_entity_name = 'HZ_PARTIES' THEN
81:
82: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
83: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
84: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_BATCHES', FALSE);
85:
86: Open C1;
87: Close C1;
88:

Line 89: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');

85:
86: Open C1;
87: Close C1;
88:
89: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
90: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_BATCHES', FALSE);
91:
92: /*delete the existing target party ID */
93: -- DELETE FROM FUN_TRX_BATCHES

Line 90: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_BATCHES', FALSE);

86: Open C1;
87: Close C1;
88:
89: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
90: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_BATCHES', FALSE);
91:
92: /*delete the existing target party ID */
93: -- DELETE FROM FUN_TRX_BATCHES
94: -- WHERE party_id = p_To_Fk_id;

Line 123: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_BATCHES_LOCK');

119: END IF;
120:
121: EXCEPTION
122: WHEN RESOURCE_BUSY THEN
123: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_BATCHES_LOCK');
124: FND_MSG_PUB.ADD;
125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
126: WHEN OTHERS THEN
127: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

Line 127: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

123: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_BATCHES_LOCK');
124: FND_MSG_PUB.ADD;
125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
126: WHEN OTHERS THEN
127: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MSG_PUB.ADD;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131:

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

124: FND_MSG_PUB.ADD;
125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
126: WHEN OTHERS THEN
127: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MSG_PUB.ADD;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131:
132: END merge_trx_batches;

Line 207: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');

203:
204: IF p_parent_entity_name = 'HZ_PARTIES' THEN
205:
206: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
207: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
208: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);
209:
210: Open C1;
211: Close C1;

Line 208: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);

204: IF p_parent_entity_name = 'HZ_PARTIES' THEN
205:
206: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
207: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
208: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);
209:
210: Open C1;
211: Close C1;
212:

Line 213: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');

209:
210: Open C1;
211: Close C1;
212:
213: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
214: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);
215:
216: /*delete the existing target party ID */
217: -- DELETE FROM FUN_TRX_BATCHES

Line 214: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);

210: Open C1;
211: Close C1;
212:
213: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
214: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);
215:
216: /*delete the existing target party ID */
217: -- DELETE FROM FUN_TRX_BATCHES
218: -- WHERE party_id = p_To_Fk_id;

Line 238: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_HEADERS_LOCK');

234: END IF;
235:
236: EXCEPTION
237: WHEN RESOURCE_BUSY THEN
238: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_HEADERS_LOCK');
239: FND_MSG_PUB.ADD;
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
241: WHEN OTHERS THEN
242: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

Line 242: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

238: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_HEADERS_LOCK');
239: FND_MSG_PUB.ADD;
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
241: WHEN OTHERS THEN
242: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
243: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
244: FND_MSG_PUB.ADD;
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:

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

239: FND_MSG_PUB.ADD;
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
241: WHEN OTHERS THEN
242: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
243: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
244: FND_MSG_PUB.ADD;
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: END merge_trx_headers;

Line 322: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');

318:
319: IF p_parent_entity_name = 'HZ_PARTIES' THEN
320:
321: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
322: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
323: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);
324:
325: Open C1;
326: Close C1;

Line 323: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);

319: IF p_parent_entity_name = 'HZ_PARTIES' THEN
320:
321: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
322: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
323: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);
324:
325: Open C1;
326: Close C1;
327:

Line 328: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');

324:
325: Open C1;
326: Close C1;
327:
328: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
329: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);
330:
331: /*delete the existing target party ID */
332: -- DELETE FROM FUN_TRX_BATCHES

Line 329: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);

325: Open C1;
326: Close C1;
327:
328: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
329: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);
330:
331: /*delete the existing target party ID */
332: -- DELETE FROM FUN_TRX_BATCHES
333: -- WHERE party_id = p_To_Fk_id;

Line 353: FND_MESSAGE.SET_NAME('FUN','FUN_DIST_LINES_LOCK');

349: END IF;
350:
351: EXCEPTION
352: WHEN RESOURCE_BUSY THEN
353: FND_MESSAGE.SET_NAME('FUN','FUN_DIST_LINES_LOCK');
354: FND_MSG_PUB.ADD;
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
356: WHEN OTHERS THEN
357: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

Line 357: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

353: FND_MESSAGE.SET_NAME('FUN','FUN_DIST_LINES_LOCK');
354: FND_MSG_PUB.ADD;
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
356: WHEN OTHERS THEN
357: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
358: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
359: FND_MSG_PUB.ADD;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:

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

354: FND_MSG_PUB.ADD;
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
356: WHEN OTHERS THEN
357: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
358: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
359: FND_MSG_PUB.ADD;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: END merge_dist_lines;

Line 436: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');

432: IF p_from_FK_id <> p_to_FK_id THEN
433:
434: IF p_parent_entity_name = 'HZ_PARTY_SITE_USES' THEN
435:
436: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
437: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);
438:
439: Open C1;
440: Close C1;

Line 437: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);

433:
434: IF p_parent_entity_name = 'HZ_PARTY_SITE_USES' THEN
435:
436: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
437: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);
438:
439: Open C1;
440: Close C1;
441:

Line 442: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');

438:
439: Open C1;
440: Close C1;
441:
442: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
443: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);
444:
445: /*delete the existing target party ID */
446: -- DELETE FROM FUN_TRX_BATCHES

Line 443: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);

439: Open C1;
440: Close C1;
441:
442: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
443: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);
444:
445: /*delete the existing target party ID */
446: -- DELETE FROM FUN_TRX_BATCHES
447: -- WHERE party_id = p_To_Fk_id;

Line 465: FND_MESSAGE.SET_NAME('FUN','FUN_CUSTOMER_MAPS_LOCK');

461: END IF;
462:
463: EXCEPTION
464: WHEN RESOURCE_BUSY THEN
465: FND_MESSAGE.SET_NAME('FUN','FUN_CUSTOMER_MAPS_LOCK');
466: FND_MSG_PUB.ADD;
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
468: WHEN OTHERS THEN
469: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

Line 469: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

465: FND_MESSAGE.SET_NAME('FUN','FUN_CUSTOMER_MAPS_LOCK');
466: FND_MSG_PUB.ADD;
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
468: WHEN OTHERS THEN
469: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
470: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
471: FND_MSG_PUB.ADD;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473:

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

466: FND_MSG_PUB.ADD;
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
468: WHEN OTHERS THEN
469: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
470: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
471: FND_MSG_PUB.ADD;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473:
474: END merge_customer_maps;

Line 548: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');

544: IF p_from_FK_id <> p_to_FK_id THEN
545:
546: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
547:
548: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
549: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);
550:
551: Open C1;
552: Close C1;

Line 549: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);

545:
546: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
547:
548: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
549: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);
550:
551: Open C1;
552: Close C1;
553:

Line 554: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');

550:
551: Open C1;
552: Close C1;
553:
554: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
555: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);
556:
557: /*delete the existing target party ID */
558: -- DELETE FROM FUN_TRX_BATCHES

Line 555: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);

551: Open C1;
552: Close C1;
553:
554: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
555: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);
556:
557: /*delete the existing target party ID */
558: -- DELETE FROM FUN_TRX_BATCHES
559: -- WHERE party_id = p_To_Fk_id;

Line 577: FND_MESSAGE.SET_NAME('FUN','FUN_SUPPLIER_MAPS_LOCK');

573: END IF;
574:
575: EXCEPTION
576: WHEN RESOURCE_BUSY THEN
577: FND_MESSAGE.SET_NAME('FUN','FUN_SUPPLIER_MAPS_LOCK');
578: FND_MSG_PUB.ADD;
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
580: WHEN OTHERS THEN
581: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

Line 581: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');

577: FND_MESSAGE.SET_NAME('FUN','FUN_SUPPLIER_MAPS_LOCK');
578: FND_MSG_PUB.ADD;
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
580: WHEN OTHERS THEN
581: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
582: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
583: FND_MSG_PUB.ADD;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585:

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

578: FND_MSG_PUB.ADD;
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
580: WHEN OTHERS THEN
581: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');
582: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
583: FND_MSG_PUB.ADD;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585:
586: END merge_supplier_maps;