DBA Data[Home] [Help]

APPS.JTF_FM_PARTY_MERGE_PKG dependencies on ARP_MESSAGE

Line 43: arp_message.set_line('JTF_FM_PARTY_MERGE_PKG.JTF_FM_MERGE_PARTY()+');

39: RESOURCE_BUSY EXCEPTION;
40: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
41:
42: BEGIN
43: arp_message.set_line('JTF_FM_PARTY_MERGE_PKG.JTF_FM_MERGE_PARTY()+');
44:
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: select merge_reason_code

Line 81: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

77:
78: if p_from_fk_id <> p_to_fk_id then
79: begin
80: -- obtain lock on records to be updated.
81: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
82: arp_message.set_token('TABLE_NAME', p_entity_name, FALSE);
83:
84:
85: open c2;

Line 82: arp_message.set_token('TABLE_NAME', p_entity_name, FALSE);

78: if p_from_fk_id <> p_to_fk_id then
79: begin
80: -- obtain lock on records to be updated.
81: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
82: arp_message.set_token('TABLE_NAME', p_entity_name, FALSE);
83:
84:
85: open c2;
86: fetch c2 into l_party_name;

Line 119: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

115: END IF;
116:
117: l_count := sql%rowcount;
118:
119: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
120: arp_message.set_token('NUM_ROWS', to_char(l_count) );
121:
122:
123: exception

Line 120: arp_message.set_token('NUM_ROWS', to_char(l_count) );

116:
117: l_count := sql%rowcount;
118:
119: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
120: arp_message.set_token('NUM_ROWS', to_char(l_count) );
121:
122:
123: exception
124: when resource_busy then

Line 125: arp_message.set_line(g_proc_name || '.' || l_api_name ||

121:
122:
123: exception
124: when resource_busy then
125: arp_message.set_line(g_proc_name || '.' || l_api_name ||
126: '; Could not obtain lock for records in table ' ||
127: p_entity_name ||
128: ' for party_id = ' || p_from_fk_id );
129: x_return_status := FND_API.G_RET_STS_ERROR;

Line 133: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

129: x_return_status := FND_API.G_RET_STS_ERROR;
130: raise;
131:
132: when others then
133: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: raise;
136: end;
137: end if;