DBA Data[Home] [Help]

APPS.ASO_CONTRACT_TERMS_PUB dependencies on FND_API

Line 16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

12: g_file_name CONSTANT VARCHAR2 (12) := 'asopktcb.pls';
13:
14: PROCEDURE Get_Article_Variable_Values (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
17: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
18: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
19: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: p_doc_id IN NUMBER,

Line 32: IF FND_API.to_Boolean( p_init_msg_list ) THEN

28: -- Standard Start of API savepoint
29: SAVEPOINT Get_Article_Variable_PUB;
30:
31: -- Initialize message list if p_init_msg_list is set to TRUE.
32: IF FND_API.to_Boolean( p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;
35:
36: -- initialize G_Debug_Flag

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: -- initialize G_Debug_Flag
37: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
38:
39: -- Initialize API return status to success
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
43: aso_debug_pub.add('Get_Article_Variable_Values PUB - Begin', 1, 'Y');
44: END IF;

Line 65: IF x_return_status <> fnd_api.g_ret_sts_success THEN

61: 'Y'
62: );
63: END IF;
64:
65: IF x_return_status <> fnd_api.g_ret_sts_success THEN
66: RAISE fnd_api.g_exc_error;
67: END IF;
68:
69: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 66: RAISE fnd_api.g_exc_error;

62: );
63: END IF;
64:
65: IF x_return_status <> fnd_api.g_ret_sts_success THEN
66: RAISE fnd_api.g_exc_error;
67: END IF;
68:
69: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
70: aso_debug_pub.add('Get_Article_Variable_Values PUB : End ', 1, 'N');

Line 79: WHEN FND_API.G_EXC_ERROR THEN

75: p_data => x_msg_data
76: );
77:
78: EXCEPTION
79: WHEN FND_API.G_EXC_ERROR THEN
80: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
81: P_API_NAME => L_API_NAME
82: ,P_PKG_NAME => G_PKG_NAME
83: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

87: ,X_MSG_COUNT => X_MSG_COUNT
88: ,X_MSG_DATA => X_MSG_DATA
89: ,X_RETURN_STATUS => X_RETURN_STATUS);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
93: P_API_NAME => L_API_NAME
94: ,P_PKG_NAME => G_PKG_NAME
95: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 119: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

115: END Get_Article_Variable_Values;
116:
117: PROCEDURE Get_Line_Variable_Values (
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
120: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
121: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
122: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
123: p_doc_id IN NUMBER,

Line 136: IF FND_API.to_Boolean( p_init_msg_list ) THEN

132: -- Standard Start of API savepoint
133: SAVEPOINT Get_Line_Variable_Values_PUB;
134:
135: -- Initialize message list if p_init_msg_list is set to TRUE.
136: IF FND_API.to_Boolean( p_init_msg_list ) THEN
137: FND_MSG_PUB.initialize;
138: END IF;
139:
140: -- initialize G_Debug_Flag

Line 144: x_return_status := FND_API.G_RET_STS_SUCCESS;

140: -- initialize G_Debug_Flag
141: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
142:
143: -- Initialize API return status to success
144: x_return_status := FND_API.G_RET_STS_SUCCESS;
145:
146: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
147: aso_debug_pub.add('Get_Line_Variable_Values PUB - Begin', 1, 'Y');
148: END IF;

Line 170: IF x_return_status <> fnd_api.g_ret_sts_success THEN

166: 'Y'
167: );
168: END IF;
169:
170: IF x_return_status <> fnd_api.g_ret_sts_success THEN
171: RAISE fnd_api.g_exc_error;
172: END IF;
173:
174: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 171: RAISE fnd_api.g_exc_error;

167: );
168: END IF;
169:
170: IF x_return_status <> fnd_api.g_ret_sts_success THEN
171: RAISE fnd_api.g_exc_error;
172: END IF;
173:
174: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
175: aso_debug_pub.add('Get_Line_Variable_Values PUB : End ', 1, 'N');

Line 184: WHEN FND_API.G_EXC_ERROR THEN

180: p_data => x_msg_data
181: );
182:
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
186: P_API_NAME => L_API_NAME
187: ,P_PKG_NAME => G_PKG_NAME
188: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

192: ,X_MSG_COUNT => X_MSG_COUNT
193: ,X_MSG_DATA => X_MSG_DATA
194: ,X_RETURN_STATUS => X_RETURN_STATUS);
195:
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
198: P_API_NAME => L_API_NAME
199: ,P_PKG_NAME => G_PKG_NAME
200: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 224: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

220: END Get_Line_Variable_Values;
221:
222: FUNCTION OK_To_Commit (
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
225: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
226: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
227: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
228: p_doc_id IN NUMBER,

Line 234: l_return VARCHAR2 (1) := FND_API.G_TRUE;

230: p_validation_string IN VARCHAR2
231: ) RETURN VARCHAR2 IS
232: l_api_version CONSTANT NUMBER := 1.0;
233: l_api_name CONSTANT VARCHAR2(45) := 'OK_To_Commit';
234: l_return VARCHAR2 (1) := FND_API.G_TRUE;
235:
236: BEGIN
237:
238: -- Standard Start of API savepoint

Line 242: IF FND_API.to_Boolean( p_init_msg_list ) THEN

238: -- Standard Start of API savepoint
239: SAVEPOINT OK_To_Commit_PUB;
240:
241: -- Initialize message list if p_init_msg_list is set to TRUE.
242: IF FND_API.to_Boolean( p_init_msg_list ) THEN
243: FND_MSG_PUB.initialize;
244: END IF;
245:
246: -- initialize G_Debug_Flag

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: -- initialize G_Debug_Flag
247: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
248:
249: -- Initialize API return status to success
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
253: aso_debug_pub.add('OK_To_Commit PUB - Begin', 1, 'Y');
254: END IF;