DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_TYPES_PUB dependencies on FND_API

Line 38: x_return_status := FND_API.G_RET_STS_ERROR;

34: X_NAME => null,
35: X_DESCRIPTION => null);
36: Exception
37: When Others Then
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: x_msg_count := 1;
40: x_msg_data := nvl(FND_MESSAGE.GET_ENCODED,SQLERRM);
41: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_PUB',
42: p_procedure_name => 'delete');

Line 57: (p_encoded => FND_API.G_TRUE,

53:
54: if l_msg_count > 0 then
55: if l_msg_count = 1 then
56: PA_INTERFACE_UTILS_PUB.get_messages
57: (p_encoded => FND_API.G_TRUE,
58: p_msg_index => 1,
59: p_msg_count => l_msg_count,
60: p_msg_data => l_msg_data,
61: p_data => l_data,

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: DELETE
74: FROM pa_pt_co_impl_statuses
75: WHERE fin_plan_type_id=p_fin_plan_type_id;
76:
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: end if;
80:
81: Exception

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

79: end if;
80:
81: Exception
82: when OTHERS then
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := 1;
85: x_msg_data := SQLERRM;
86: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_PUB',
87: p_procedure_name => 'delete');

Line 88: raise FND_API.G_EXC_UNEXPECTED_ERROR;

84: x_msg_count := 1;
85: x_msg_data := SQLERRM;
86: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPES_PUB',
87: p_procedure_name => 'delete');
88: raise FND_API.G_EXC_UNEXPECTED_ERROR;
89: end delete;
90:
91: END pa_fin_plan_types_pub;