DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_MERGE_PKG dependencies on FND_API

Line 29: x_return_status := FND_API.G_RET_STS_SUCCESS;

25: l_api_version_number CONSTANT NUMBER := 2.0;
26: l_merge_reason_code VARCHAR2(30);
27: BEGIN
28: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.SALES_LEAD_MERGE starts : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: select merge_reason_code into l_merge_reason_code
32: from HZ_MERGE_BATCH
33: where batch_id = p_batch_id;

Line 166: x_return_status := FND_API.G_RET_STS_ERROR;

162: END IF;
163: EXCEPTION
164: WHEN OTHERS THEN
165: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: raise;
168: END;
169: END IF;
170:

Line 191: x_return_status := FND_API.G_RET_STS_SUCCESS;

187: l_api_version_number CONSTANT NUMBER := 2.0;
188: l_merge_reason_code VARCHAR2(30);
189: BEGIN
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.LEAD_CONTACT_MERGE starts : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: select merge_reason_code into l_merge_reason_code
194: from HZ_MERGE_BATCH
195: where batch_id = p_batch_id;

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302: END IF;
303: EXCEPTION
304: WHEN OTHERS THEN
305: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: raise;
308: END;
309: END IF;
310: