DBA Data[Home] [Help]

APPS.OKL_EXT_BILLING_CHARGES_PUB dependencies on FND_API

Line 44: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

40: ------------------------------------------------------------
41: -- Start processing
42: ------------------------------------------------------------
43:
44: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
45:
46: SAVEPOINT sp_bill_charges;
47:
48: l_name := p_name;

Line 78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

74: ,p_date_transmission => l_date_transmission
75: ,p_origin => l_origin
76: ,p_destination => l_destination);
77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;

Line 79: RAISE Fnd_Api.G_EXC_ERROR;

75: ,p_origin => l_origin
76: ,p_destination => l_destination);
77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:

Line 80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

76: ,p_destination => l_destination);
77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84: ------------------------------------------------------------

Line 81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84: ------------------------------------------------------------
85: ------------------------------------------------------------

Line 99: WHEN Fnd_Api.G_EXC_ERROR THEN

95: ------------------------------------------------------------
96: -- Exception handling
97: ------------------------------------------------------------
98:
99: WHEN Fnd_Api.G_EXC_ERROR THEN
100:
101: ROLLBACK TO sp_bill_charges;
102: x_return_status := Fnd_Api.G_RET_STS_ERROR;
103: Fnd_Msg_Pub.Count_and_get (

Line 102: x_return_status := Fnd_Api.G_RET_STS_ERROR;

98:
99: WHEN Fnd_Api.G_EXC_ERROR THEN
100:
101: ROLLBACK TO sp_bill_charges;
102: x_return_status := Fnd_Api.G_RET_STS_ERROR;
103: Fnd_Msg_Pub.Count_and_get (
104: p_encoded => Okc_Api.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data);

Line 108: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

104: p_encoded => Okc_Api.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data);
107:
108: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
109:
110: ROLLBACK TO sp_bill_charges;
111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
112: Fnd_Msg_Pub.Count_and_get (

Line 111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

107:
108: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
109:
110: ROLLBACK TO sp_bill_charges;
111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
112: Fnd_Msg_Pub.Count_and_get (
113: p_encoded => Okc_Api.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data);

Line 119: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

115: p_data => x_msg_data);
116:
117: WHEN OTHERS THEN
118:
119: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
120: Fnd_Msg_Pub.ADD_EXC_MSG (
121: p_pkg_name => G_PKG_NAME,
122: p_procedure_name => l_api_name);
123: Fnd_Msg_Pub.Count_and_get (