APPS.IBW_MERGE_PVT dependencies on IBW_PAGE_VIEWS

Line 8: | API registered to merge, party_id and party_relationship_id in ibw_page_views

4:
5: /*------------------------------------------------------------------------------------------------------------------------*
6: | PUBLIC PROCEDURES |
7: | MERGE_PAGES -- |
8: | API registered to merge, party_id and party_relationship_id in ibw_page_views
9: | These API's will be called when party_id in the HZ_parties will be merged.
10: *--------------------------------------------------------------------------------------------------------------------------*/
11:
12:

Line 36: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS merge started ' );

32: BEGIN
33:
34: begin
35: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
36: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS merge started ' );
37: l_message_text := fnd_message.get;
38: fnd_file.put_line(FND_FILE.LOG,l_message_text);
39: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
40: end ;

Line 62: fnd_message.set_token('DESC',' Updating ibw_page_views : Start' );

58: IF p_parent_entity_name = 'HZ_PARTIES' Then
59:
60: begin
61: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
62: fnd_message.set_token('DESC',' Updating ibw_page_views : Start' );
63: l_message_text := fnd_message.get;
64: fnd_file.put_line(FND_FILE.LOG,l_message_text);
65: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
66: end ;

Line 72: UPDATE IBW_PAGE_VIEWS SET

68: /* The below query would be executed when PARTY_ID of type 'ORGANIZATION' or 'PERSON' or 'PARTY RELATIONSHIP' is merged
69: in HZ_PARTIES Table.
70: */
71:
72: UPDATE IBW_PAGE_VIEWS SET
73: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
74: party_relationship_id = DECODE( party_relationship_id,p_from_fk_id,p_to_fk_id, party_relationship_id),
75: 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*/
76: last_update_date = hz_utility_pub.last_update_date,

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

86:
87:
88: begin
89: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
90: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS Rows updated :'||to_char(l_count) );
91: l_message_text := fnd_message.get;
92: fnd_file.put_line(FND_FILE.LOG,l_message_text);
93: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
94: end ;

Line 104: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_PAGES; Could not obtain lock on table IBW_PAGE_VIEWS' );

100: Exception
101: When RESOURCE_BUSY Then
102: begin
103: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
104: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_PAGES; Could not obtain lock on table IBW_PAGE_VIEWS' );
105: l_message_text := fnd_message.get;
106: fnd_file.put_line(FND_FILE.LOG,l_message_text);
107: end ;
108: x_return_status := FND_API.G_RET_STS_ERROR;