DBA Data[Home] [Help]

APPS.PVX_ATTACHMENT_INT dependencies on FND_API

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

27: -- p_media_id - Document Content reference.
28:
29: PROCEDURE Add_Attachment(
30: p_api_version_number IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_seq_num IN VARCHAR2
34: ,p_category_id IN VARCHAR2
35: ,p_document_description IN VARCHAR2

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

28:
29: PROCEDURE Add_Attachment(
30: p_api_version_number IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_seq_num IN VARCHAR2
34: ,p_category_id IN VARCHAR2
35: ,p_document_description IN VARCHAR2
36: ,p_datatype_id IN VARCHAR2

Line 63: IF NOT FND_API.Compatible_API_Call (l_api_version

59:
60: -- Standard Start of API savepoint
61: SAVEPOINT Add_ATTACHMENT_PVT;
62:
63: IF NOT FND_API.Compatible_API_Call (l_api_version
64: ,P_Api_Version_Number
65: ,l_api_name
66: ,G_PKG_NAME )
67: THEN

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: ,P_Api_Version_Number
65: ,l_api_name
66: ,G_PKG_NAME )
67: THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70:
71:
72: OPEN c_get_file_name( p_media_id);

Line 81: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84:
85:
86:
87: -- Initialize API return status to error, i.e, its not duplicate
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90:
91: FND_WEBATTCH.Add_Attachment(
92: seq_num => p_seq_num

Line 112: IF FND_API.to_Boolean( p_commit )

108: );
109:
110: -- End of API body.
111: -- Standard check of p_commit.
112: IF FND_API.to_Boolean( p_commit )
113: THEN
114: COMMIT WORK;
115: END IF;
116:

Line 126: WHEN FND_API.G_EXC_ERROR THEN

122: p_data => x_msg_data
123: );
124:
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
128: P_API_NAME => L_API_NAME
129: ,P_PKG_NAME => G_PKG_NAME
130: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

134: ,X_MSG_COUNT => X_MSG_COUNT
135: ,X_MSG_DATA => X_MSG_DATA
136: ,X_RETURN_STATUS => X_RETURN_STATUS);
137:
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
140: P_API_NAME => L_API_NAME
141: ,P_PKG_NAME => G_PKG_NAME
142: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 167: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

163:
164:
165: PROCEDURE Delete_Attachments(
166: p_api_version_number IN NUMBER
167: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
168: ,p_commit IN VARCHAR2 := FND_API.g_false
169: ,p_quote_header_id IN NUMBER
170: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
171: ,x_return_status OUT NOCOPY VARCHAR2

Line 168: ,p_commit IN VARCHAR2 := FND_API.g_false

164:
165: PROCEDURE Delete_Attachments(
166: p_api_version_number IN NUMBER
167: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
168: ,p_commit IN VARCHAR2 := FND_API.g_false
169: ,p_quote_header_id IN NUMBER
170: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
171: ,x_return_status OUT NOCOPY VARCHAR2
172: ,x_msg_count OUT NOCOPY NUMBER

Line 205: IF NOT FND_API.Compatible_API_Call (l_api_version

201:
202: -- Standard Start of API savepoint
203: SAVEPOINT DELETE_ATTACHMENTS_PVT;
204:
205: IF NOT FND_API.Compatible_API_Call (l_api_version
206: ,P_Api_Version_Number
207: ,l_api_name
208: ,G_PKG_NAME )
209: THEN

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: ,P_Api_Version_Number
207: ,l_api_name
208: ,G_PKG_NAME )
209: THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213:
214: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 215: IF FND_API.to_Boolean(p_init_msg_list) THEN

211: END IF;
212:
213:
214: -- Initialize message list if p_init_msg_list is set to TRUE.
215: IF FND_API.to_Boolean(p_init_msg_list) THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218:
219:

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227:
228:
229:
230: -- Initialize API return status to error, i.e, its not duplicate
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: FOR i in 1..p_quote_attachment_ids.COUNT LOOP
234:
235: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 265: RAISE fnd_api.g_exc_error;

261: 'QUOTE_HEADER_ID', FALSE);
262: fnd_msg_pub.ADD;
263: END IF;
264:
265: RAISE fnd_api.g_exc_error;
266: ELSE
267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
268: aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');
269: END IF;

Line 306: IF FND_API.to_Boolean( p_commit )

302: END LOOP;
303:
304: -- End of API body.
305: -- Standard check of p_commit.
306: IF FND_API.to_Boolean( p_commit )
307: THEN
308: COMMIT WORK;
309: END IF;
310:

Line 320: WHEN FND_API.G_EXC_ERROR THEN

316: p_data => x_msg_data
317: );
318:
319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN
321: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
322: P_API_NAME => L_API_NAME
323: ,P_PKG_NAME => G_PKG_NAME
324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

328: ,X_MSG_COUNT => X_MSG_COUNT
329: ,X_MSG_DATA => X_MSG_DATA
330: ,X_RETURN_STATUS => X_RETURN_STATUS);
331:
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
334: P_API_NAME => L_API_NAME
335: ,P_PKG_NAME => G_PKG_NAME
336: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR