DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PUB dependencies on FND_API

Line 36: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

32: ------------------------------------------------------------
33: -- Start processing
34: ------------------------------------------------------------
35:
36: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
37:
38: SAVEPOINT sp_bill_streams;
39:
40: l_contract_number := p_contract_number;

Line 67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

63: p_from_bill_date => l_from_bill_date,
64: p_to_bill_date => l_to_bill_date);
65:
66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;

Line 68: RAISE Fnd_Api.G_EXC_ERROR;

64: p_to_bill_date => l_to_bill_date);
65:
66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:

Line 69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

65:
66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: ------------------------------------------------------------

Line 70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: ------------------------------------------------------------
74: ------------------------------------------------------------

Line 88: WHEN Fnd_Api.G_EXC_ERROR THEN

84: ------------------------------------------------------------
85: -- Exception handling
86: ------------------------------------------------------------
87:
88: WHEN Fnd_Api.G_EXC_ERROR THEN
89:
90: ROLLBACK TO sp_bill_streams;
91: x_return_status := Fnd_Api.G_RET_STS_ERROR;
92: Fnd_Msg_Pub.Count_and_get (

Line 91: x_return_status := Fnd_Api.G_RET_STS_ERROR;

87:
88: WHEN Fnd_Api.G_EXC_ERROR THEN
89:
90: ROLLBACK TO sp_bill_streams;
91: x_return_status := Fnd_Api.G_RET_STS_ERROR;
92: Fnd_Msg_Pub.Count_and_get (
93: p_encoded => Okc_Api.G_FALSE,
94: p_count => x_msg_count,
95: p_data => x_msg_data);

Line 97: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

93: p_encoded => Okc_Api.G_FALSE,
94: p_count => x_msg_count,
95: p_data => x_msg_data);
96:
97: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
98:
99: ROLLBACK TO sp_bill_streams;
100: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
101: Fnd_Msg_Pub.Count_and_get (

Line 100: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

96:
97: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
98:
99: ROLLBACK TO sp_bill_streams;
100: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
101: Fnd_Msg_Pub.Count_and_get (
102: p_encoded => Okc_Api.G_FALSE,
103: p_count => x_msg_count,
104: p_data => x_msg_data);

Line 108: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

104: p_data => x_msg_data);
105:
106: WHEN OTHERS THEN
107:
108: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
109: Fnd_Msg_Pub.ADD_EXC_MSG (
110: p_pkg_name => G_PKG_NAME,
111: p_procedure_name => l_api_name);
112: Fnd_Msg_Pub.Count_and_get (