APPS.FUN_PARTY_MERGE_PUB dependencies on FUN_TRX_BATCHES

Line 32: FUN_TRX_BATCHES

28: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
29:
30: Cursor C1 is
31: Select 'X' from
32: FUN_TRX_BATCHES
33: Where initiator_id = p_from_fk_id
34: for update nowait;
35:
36: Cursor C2 is

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 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 93: -- DELETE FROM FUN_TRX_BATCHES

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;
95:
96: /* Update the "From" Party_ID to be equal to the new target */
97: UPDATE FUN_TRX_BATCHES

Line 97: UPDATE FUN_TRX_BATCHES

93: -- DELETE FROM FUN_TRX_BATCHES
94: -- WHERE party_id = p_To_Fk_id;
95:
96: /* Update the "From" Party_ID to be equal to the new target */
97: UPDATE FUN_TRX_BATCHES
98: SET initiator_id = p_To_FK_id,
99: LAST_UPDATED_BY = hz_utility_pub.user_id,
100: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
101: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

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 217: -- DELETE FROM FUN_TRX_BATCHES

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;
219:
220:
221: /* Update the "From" Party_ID to be equal to the new target */

Line 332: -- DELETE FROM FUN_TRX_BATCHES

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;
334:
335:
336: /* Update the "From" Party_ID to be equal to the new target */

Line 446: -- DELETE FROM FUN_TRX_BATCHES

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;
448:
449:
450: /* Update the "From" Party_ID to be equal to the new target */

Line 558: -- DELETE FROM FUN_TRX_BATCHES

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;
560:
561:
562: /* Update the "From" Party_ID to be equal to the new target */