APPS.JTF_IH_PARTY_MERGE_PKG dependencies on ARP_MESSAGE

Line 54: arp_message.set_line('JTF_IH_PARTY_MERGE_PKG.JTF_IH_MERGE_PARTY()+');

50: s_Party_Type VARCHAR2(30);
51: BEGIN
52: l_api_name := 'JTF_IH_MERGE_PARTY';
53: l_count := 0;
54: arp_message.set_line('JTF_IH_PARTY_MERGE_PKG.JTF_IH_MERGE_PARTY()+');
55:
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: select merge_reason_code
58: into l_merge_reason_code

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

86:
87: if p_from_fk_id <> p_to_fk_id then
88: begin
89: -- obtain lock on records to be updated.
90: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
91: arp_message.set_token('TABLE_NAME', 'JTF_IH_INTERACTIONS', FALSE);
92:
93: open c1;
94: close c1;

Line 91: arp_message.set_token('TABLE_NAME', 'JTF_IH_INTERACTIONS', FALSE);

87: if p_from_fk_id <> p_to_fk_id then
88: begin
89: -- obtain lock on records to be updated.
90: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
91: arp_message.set_token('TABLE_NAME', 'JTF_IH_INTERACTIONS', FALSE);
92:
93: open c1;
94: close c1;
95: select party_type into s_Party_Type from hz_parties where party_id = p_to_fk_id;

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

118: ----where customer_id = p_from_fk_id;
119:
120: l_count := sql%rowcount;
121:
122: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
123: arp_message.set_token('NUM_ROWS', to_char(l_count) );
124:
125: exception
126: when resource_busy then

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

119:
120: l_count := sql%rowcount;
121:
122: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
123: arp_message.set_token('NUM_ROWS', to_char(l_count) );
124:
125: exception
126: when resource_busy then
127: arp_message.set_line(g_proc_name || '.' || l_api_name ||

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

123: arp_message.set_token('NUM_ROWS', to_char(l_count) );
124:
125: exception
126: when resource_busy then
127: arp_message.set_line(g_proc_name || '.' || l_api_name ||
128: '; Could not obtain lock for records in table ' ||
129: 'JTF_IH_INTERACTIONS for party_id = ' || p_from_fk_id );
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: --dbms_output.put_line('Busy');

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

131: --dbms_output.put_line('Busy');
132: raise;
133:
134: when others then
135: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
136: --dbms_output.put_line('Other ');
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: raise;
139: end;