DBA Data[Home] [Help]

APPS.ASO_INSTBASE_INT dependencies on FND_API

Line 31: -- := FND_API.G_FALSE

27: --
28: -- Standard IN Parameters:
29: -- p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Optional
31: -- := FND_API.G_FALSE
32: --
33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
34: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
35: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

49:
50: PROCEDURE Delete_Installation_Detail
51: (
52: p_api_version_number IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
56: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
57: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 54: p_commit IN VARCHAR2 := FND_API.G_FALSE,

50: PROCEDURE Delete_Installation_Detail
51: (
52: p_api_version_number IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
56: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
57: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58: p_line_inst_dtl_id IN NUMBER

Line 71: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

67: -- Standard Start of API savepoint
68: SAVEPOINT Delete_Installation_detail_PUB;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME)
75: THEN

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME)
75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 81: IF FND_API.to_Boolean( p_init_msg_list )

77: END IF;
78:
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list )
82: THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85:

Line 90: x_return_status := FND_API.G_RET_STS_SUCCESS;

86: -- Debug Message
87: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
88:
89: -- Initialize API return status to SUCCESS
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91:
92: IF NOT (CSI_utility_grp.ib_active())
93: then
94: -- old ib module.

Line 111: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

107:
108: END IF;
109:
110:
111: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
115:

Line 112: RAISE FND_API.G_EXC_ERROR;

108: END IF;
109:
110:
111: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
115:
116: --

Line 121: IF FND_API.to_Boolean( p_commit )

117: -- End of API body.
118: --
119:
120: -- Standard check for p_commit
121: IF FND_API.to_Boolean( p_commit )
122: THEN
123: COMMIT WORK;
124: END IF;
125:

Line 138: WHEN FND_API.G_EXC_ERROR THEN

134: p_data => x_msg_data
135: );
136:
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME

Line 139: x_return_status := FND_API.G_RET_STS_ERROR;

135: );
136:
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME
143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

145: ,X_MSG_COUNT => X_MSG_COUNT
146: ,X_MSG_DATA => X_MSG_DATA
147: ,X_RETURN_STATUS => X_RETURN_STATUS);
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

146: ,X_MSG_DATA => X_MSG_DATA
147: ,X_RETURN_STATUS => X_RETURN_STATUS);
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

157: ,X_MSG_DATA => X_MSG_DATA
158: ,X_RETURN_STATUS => X_RETURN_STATUS);
159:
160: WHEN OTHERS THEN
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
163: P_API_NAME => L_API_NAME
164: ,P_PKG_NAME => G_PKG_NAME
165: ,P_SQLERRM => sqlerrm

Line 185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

181:
182: PROCEDURE Update_Inst_Details_ORDER
183: (
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
188: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
189: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 186: p_commit IN VARCHAR2 := FND_API.G_FALSE,

182: PROCEDURE Update_Inst_Details_ORDER
183: (
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
188: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
189: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
190: p_quote_line_shipment_id IN NUMBER,

Line 224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

220: -- Standard Start of API savepoint
221: SAVEPOINT Update_Inst_details_ORder_PUB;
222:
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
225: p_api_version_number,
226: l_api_name,
227: G_PKG_NAME)
228: THEN

Line 229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

225: p_api_version_number,
226: l_api_name,
227: G_PKG_NAME)
228: THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:
232:
233: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 234: IF FND_API.to_Boolean( p_init_msg_list )

230: END IF;
231:
232:
233: -- Initialize message list if p_init_msg_list is set to TRUE.
234: IF FND_API.to_Boolean( p_init_msg_list )
235: THEN
236: FND_MSG_PUB.initialize;
237: END IF;
238:

Line 243: x_return_status := FND_API.G_RET_STS_SUCCESS;

239: -- Debug Message
240: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
241:
242: -- Initialize API return status to SUCCESS
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: if NOT (CSI_utility_grp.ib_active())
246: then
247: -- old ib module.

Line 263: raise FND_API.G_EXC_ERROR;

259: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
260: FND_MSG_PUB.Add;
261: END IF;
262: Close C_quote_line;
263: raise FND_API.G_EXC_ERROR;
264: END IF;
265: Close C_quote_line;
266:
267: Open c_csi_details(l_src_txn_line_rec.source_transaction_id);

Line 293: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

289: Close C_csi_details;
290:
291: END IF;
292:
293: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: -- Standard check for p_commit

Line 294: RAISE FND_API.G_EXC_ERROR;

290:
291: END IF;
292:
293: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: -- Standard check for p_commit
298: IF FND_API.to_Boolean( p_commit )

Line 298: IF FND_API.to_Boolean( p_commit )

294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: -- Standard check for p_commit
298: IF FND_API.to_Boolean( p_commit )
299: THEN
300: COMMIT WORK;
301: END IF;
302:

Line 315: WHEN FND_API.G_EXC_ERROR THEN

311: p_data => x_msg_data
312: );
313:
314: EXCEPTION
315: WHEN FND_API.G_EXC_ERROR THEN
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
318: P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME

Line 316: x_return_status := FND_API.G_RET_STS_ERROR;

312: );
313:
314: EXCEPTION
315: WHEN FND_API.G_EXC_ERROR THEN
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
318: P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: ,X_MSG_COUNT => X_MSG_COUNT
323: ,X_MSG_DATA => X_MSG_DATA
324: ,X_RETURN_STATUS => X_RETURN_STATUS);
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
329: P_API_NAME => L_API_NAME
330: ,P_PKG_NAME => G_PKG_NAME

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

323: ,X_MSG_DATA => X_MSG_DATA
324: ,X_RETURN_STATUS => X_RETURN_STATUS);
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
329: P_API_NAME => L_API_NAME
330: ,P_PKG_NAME => G_PKG_NAME
331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: ,X_MSG_DATA => X_MSG_DATA
335: ,X_RETURN_STATUS => X_RETURN_STATUS);
336:
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
340: P_API_NAME => L_API_NAME
341: ,P_PKG_NAME => G_PKG_NAME
342: ,P_SQLERRM => sqlerrm