DBA Data[Home] [Help]

APPS.AR_CREATE_ACCTING_SRS dependencies on FND_API

Line 4: g_exec_status VARCHAR2(1) := fnd_api.G_RET_STS_SUCCESS;

1: PACKAGE BODY ar_create_accting_srs AS
2: /*$Header: ARSACCTB.pls 120.10.12000000.2 2007/08/22 13:24:16 sgnagara ship $*/
3:
4: g_exec_status VARCHAR2(1) := fnd_api.G_RET_STS_SUCCESS;
5:
6: g_xla_run VARCHAR2(1) := 'Y';
7: --Local procedures
8: PROCEDURE log(

Line 49: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

45: BEGIN
46: FND_MSG_PUB.Reset;
47:
48: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
49: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
50: END LOOP;
51: IF (SQLERRM IS NOT NULL) THEN
52: l_msg_data := l_msg_data || SQLERRM;
53: END IF;

Line 326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

322: g_xla_run := 'N';
323: IF c_valid_date%ISOPEN THEN
324: CLOSE c_valid_date;
325: END IF;
326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
327: p_count => x_msg_count,
328: p_data => x_msg_data);
329: out(message => x_msg_data);
330: log(message => x_msg_data);

Line 379: -- RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

375: --{If required, we can control the error handling at concurrent process level
376: -- but as this is part of the accounting posting process if revrec or rev analyser fails
377: -- for now we allow the accouning for the cash receipts
378: -- IF l_dev_status IN ('TERMINATED', 'CANCELLED', 'ERROR') THEN
379: -- RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
380: -- END IF;
381: --}
382: END IF;
383: END LOOP;

Line 398: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

394: WHEN revrecdone THEN
395: IF reqs%ISOPEN THEN
396: CLOSE reqs;
397: END IF;
398: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
399: g_exec_status := fnd_api.G_RET_STS_UNEXP_ERROR;
400: WHEN OTHERS THEN
401: IF reqs%ISOPEN THEN
402: CLOSE reqs;

Line 399: g_exec_status := fnd_api.G_RET_STS_UNEXP_ERROR;

395: IF reqs%ISOPEN THEN
396: CLOSE reqs;
397: END IF;
398: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
399: g_exec_status := fnd_api.G_RET_STS_UNEXP_ERROR;
400: WHEN OTHERS THEN
401: IF reqs%ISOPEN THEN
402: CLOSE reqs;
403: END IF;