APPS.OKL_ACCT_SOURCES_PUB dependencies on FND_API

Line 33: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

29: x_asev_rec asev_rec_type;
30: l_data VARCHAR2(100);
31: l_count NUMBER ;
32: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_src_custom_status';
33: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
34: BEGIN
35: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
36: SAVEPOINT update_acct_src_custom_status;
37:

Line 35: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

31: l_count NUMBER ;
32: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_src_custom_status';
33: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
34: BEGIN
35: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
36: SAVEPOINT update_acct_src_custom_status;
37:
38: -- Populate the l_asev_rec with the passed values.
39:

Line 56: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

52: ,p_asev_rec => l_asev_rec
53: ,x_asev_rec => x_asev_rec
54: );
55:
56: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
57: RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
60: END IF;

Line 57: RAISE Fnd_Api.G_EXC_ERROR;

53: ,x_asev_rec => x_asev_rec
54: );
55:
56: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
57: RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:

Line 58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

54: );
55:
56: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
57: RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: /* re-assign local record structure using output record from pvt api */

Line 59: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

55:
56: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
57: RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: /* re-assign local record structure using output record from pvt api */
63: l_asev_rec := x_asev_rec;

Line 66: WHEN Fnd_Api.G_EXC_ERROR THEN

62: /* re-assign local record structure using output record from pvt api */
63: l_asev_rec := x_asev_rec;
64:
65: EXCEPTION
66: WHEN Fnd_Api.G_EXC_ERROR THEN
67: ROLLBACK TO update_acct_src_custom_status;
68: x_return_status := Fnd_Api.G_RET_STS_ERROR;
69:
70: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 68: x_return_status := Fnd_Api.G_RET_STS_ERROR;

64:
65: EXCEPTION
66: WHEN Fnd_Api.G_EXC_ERROR THEN
67: ROLLBACK TO update_acct_src_custom_status;
68: x_return_status := Fnd_Api.G_RET_STS_ERROR;
69:
70: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);

Line 74: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

70: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
73:
74: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
75: ROLLBACK TO update_acct_src_custom_status;
76: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
77: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
78: ,p_count => x_msg_count

Line 76: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

72: ,p_data => x_msg_data);
73:
74: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
75: ROLLBACK TO update_acct_src_custom_status;
76: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
77: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
78: ,p_count => x_msg_count
79: ,p_data => x_msg_data);
80:

Line 88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

84: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
85: ,p_count => x_msg_count
86: ,p_data => x_msg_data);
87: -- notify caller of an UNEXPECTED error
88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
89:
90: END update_acct_src_custom_status;
91:
92: