DBA Data[Home] [Help]

APPS.AS_TAP_MERGE_PKG dependencies on FND_API

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
72:
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: select merge_reason_code into l_merge_reason_code
76: from HZ_MERGE_BATCH
77: where batch_id = p_batch_id;

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

240: EXCEPTION
241: WHEN OTHERS THEN
242: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '
243: ||p_parent_entity_name|| sqlerrm);
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: raise;
246: END;
247: END IF;
248:

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: l_merge_reason_code VARCHAR2(30);
267: begin
268: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG .TAP_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
269:
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: select merge_reason_code into l_merge_reason_code
273: from HZ_MERGE_BATCH
274: where batch_id = p_batch_id;

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365: END IF;
366: EXCEPTION
367: WHEN OTHERS THEN
368: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: raise;
371: END;
372: END IF;
373: