DBA Data[Home] [Help]

APPS.AS_INTEREST_MERGE_PKG dependencies on FND_API

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28: BEGIN
29:
30: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_INTEREST_MERGE_PKG.INTEREST_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
31:
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: select merge_reason_code into l_merge_reason_code
35: from HZ_MERGE_BATCH
36: where batch_id = p_batch_id;

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: END IF;
119: EXCEPTION
120: WHEN OTHERS THEN
121: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: raise;
124: END;
125: END IF;
126:

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145: BEGIN
146:
147: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_INTEREST_MERGE_PKG.CURRENT_ENV_MERGE start : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
148:
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: select merge_reason_code into l_merge_reason_code
152: from HZ_MERGE_BATCH
153: where batch_id = p_batch_id;

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: END IF;
220: EXCEPTION
221: WHEN OTHERS THEN
222: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: raise;
225: END;
226: END IF;
227: