APPS.IBW_MERGE_PVT dependencies on IBW_SITE_VISITS

Line 128: | API registered to merge, party_id in ibw_site_visits

124:
125: /*------------------------------------------------------------------------------------------------------------------------*
126: | PUBLIC PROCEDURES |
127: | MERGE_SITES -- |
128: | API registered to merge, party_id in ibw_site_visits
129: | These API's will be called when party_id in the HZ_parties will be merged.
130: *--------------------------------------------------------------------------------------------------------------------------*/
131:
132: PROCEDURE MERGE_SITES(

Line 156: fnd_message.set_token('DESC',' IBW_SITE_VISITS merge started ' );

152: BEGIN
153:
154: begin
155: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
156: fnd_message.set_token('DESC',' IBW_SITE_VISITS merge started ' );
157: l_message_text := fnd_message.get;
158: fnd_file.put_line(FND_FILE.LOG,l_message_text);
159: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
160: end ;

Line 181: fnd_message.set_token('DESC',' Updating ibw_site_visits : Start' );

177: IF p_parent_entity_name = 'HZ_PARTIES' Then
178:
179: begin
180: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
181: fnd_message.set_token('DESC',' Updating ibw_site_visits : Start' );
182: l_message_text := fnd_message.get;
183: fnd_file.put_line(FND_FILE.LOG,l_message_text);
184: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
185: end ;

Line 191: UPDATE IBW_SITE_VISITS SET

187: /* The below query would be executed when PARTY_ID of type 'ORGANIZATION' or 'PERSON' is merged
188: in HZ_PARTIES Table.
189: */
190:
191: UPDATE IBW_SITE_VISITS SET
192: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
193: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,

Line 206: fnd_message.set_token('DESC',' IBW_SITE_VISITS Rows updated :'||to_char(l_count) );

202: l_count := sql%rowcount;
203:
204: begin
205: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
206: fnd_message.set_token('DESC',' IBW_SITE_VISITS Rows updated :'||to_char(l_count) );
207: l_message_text := fnd_message.get;
208: fnd_file.put_line(FND_FILE.LOG,l_message_text);
209: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
210: end ;

Line 221: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_SITES; Could not obtain lock on table IBW_SITE_VISITS' );

217: Exception
218: When RESOURCE_BUSY Then
219: begin
220: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
221: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_SITES; Could not obtain lock on table IBW_SITE_VISITS' );
222: l_message_text := fnd_message.get;
223: fnd_file.put_line(FND_FILE.LOG,l_message_text);
224: end ;
225: