APPS.CS_CH_PARTY_MERGE_PKG dependencies on FND_API

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72: BEGIN
73:
74: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CH_ALL_MERGE_SITE_ID()+');
75:
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: select merge_reason_code
79: into l_merge_reason_code
80: from hz_merge_batch

Line 142: x_return_status := FND_API.G_RET_STS_ERROR;

138: when resource_busy then
139: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' ||
140: 'CS_ESTIMATE_DETAILS for bill_to_party_id / ship_to_party_id ' ||
141: 'bill_to_contact_id / ship_to_contact_id = ' || p_from_fk_id );
142: x_return_status := FND_API.G_RET_STS_ERROR;
143: raise;
144:
145: when others then
146: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

143: raise;
144:
145: when others then
146: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: raise;
149: end;
150:
151: end if; -- if p_from_fk_id <> p_to_fk_id

Line 194: x_return_status := FND_API.G_RET_STS_SUCCESS;

190:
191: BEGIN
192: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CH_ALL_MERGE_SITE_ID()+');
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;
195:
196: select merge_reason_code
197: into l_merge_reason_code
198: from hz_merge_batch

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

280: when resource_busy then
281: arp_message.set_line(g_proc_name || '.' || l_api_name ||
282: '; Could not obtain lock for records in table ' ||
283: 'CS_ESTIMATE_DETAILS for invoice_to_org_id/ship_to_org_id = ' || p_from_fk_id );
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: raise;
286:
287: when others then
288: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: raise;
286:
287: when others then
288: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: raise;
291: end;
292: end if;
293:

Line 344: x_return_status := FND_API.G_RET_STS_SUCCESS;

340:
341: BEGIN
342: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CHG_ALL_SETUP_PARTY()+');
343:
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346:
347: select merge_reason_code
348: into l_merge_reason_code

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421:
422: exception
423: when resource_busy then
424: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CS_CHG_SUB_RESTRICTIONS for value_object_id' || 'bill_to_contact_id / ship_to_contact_id = ' || p_from_fk_id );
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: raise;
427:
428: when others then
429: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: raise;
427:
428: when others then
429: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: raise;
432: end;
433:
434: end if; -- if p_from_fk_id <> p_to_fk_id