APPS.HZ_MERGE_BATCH_PUB dependencies on FND_API

Line 88: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

84: p_batch_delete,
85: p_merge_reason_code,
86: x_return_status);
87:
88: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: -- call table-handler to insert the record

Line 89: RAISE FND_API.G_EXC_ERROR;

85: p_merge_reason_code,
86: x_return_status);
87:
88: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: -- call table-handler to insert the record
93: HZ_MERGE_BATCH_PKG.INSERT_ROW(

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

177: +===========================================================================**/
178:
179: procedure create_merge_batch (
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
182: p_commit IN VARCHAR2:= FND_API.G_FALSE,
183: p_batch_name IN VARCHAR2,
184: p_batch_commit IN VARCHAR2,
185: p_batch_delete IN VARCHAR2,

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

178:
179: procedure create_merge_batch (
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
182: p_commit IN VARCHAR2:= FND_API.G_FALSE,
183: p_batch_name IN VARCHAR2,
184: p_batch_commit IN VARCHAR2,
185: p_batch_delete IN VARCHAR2,
186: p_merge_reason_code IN VARCHAR2,

Line 191: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: x_batch_id OUT NOCOPY NUMBER,
191: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
192: ) IS
193:
194: l_api_name CONSTANT VARCHAR2(30) := 'create_merge_batch';
195: l_api_version CONSTANT NUMBER := 1.0;

Line 209: IF NOT FND_API.Compatible_API_Call(

205: SAVEPOINT create_merge_batch;
206:
207:
208: -- standard call to check for call compatibility.
209: IF NOT FND_API.Compatible_API_Call(
210: l_api_version,
211: p_api_version,
212: l_api_name,
213: G_PKG_NAME)

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: p_api_version,
212: l_api_name,
213: G_PKG_NAME)
214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: -- initialize message list if p_init_msg_list is set to TRUE.
219: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 219: IF FND_API.to_Boolean(p_init_msg_list) THEN

215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: -- initialize message list if p_init_msg_list is set to TRUE.
219: IF FND_API.to_Boolean(p_init_msg_list) THEN
220: FND_MSG_PUB.initialize;
221: END IF;
222:
223: -- initialize API return status to success.

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

220: FND_MSG_PUB.initialize;
221: END IF;
222:
223: -- initialize API return status to success.
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: -- call to business logic.
227: do_create_merge_batch(
228: l_batch_name,

Line 236: IF FND_API.to_Boolean(p_commit) THEN

232: x_batch_id,
233: x_return_status);
234:
235: -- standard check of p_commit.
236: IF FND_API.to_Boolean(p_commit) THEN
237: COMMIT;
238: END IF;
239:
240: -- standard call to get message count and if count is 1, get message info.

Line 242: p_encoded => FND_API.G_FALSE,

238: END IF;
239:
240: -- standard call to get message count and if count is 1, get message info.
241: FND_MSG_PUB.Count_And_Get(
242: p_encoded => FND_API.G_FALSE,
243: p_count => x_msg_count,
244: p_data => x_msg_data);
245:
246: EXCEPTION

Line 247: WHEN FND_API.G_EXC_ERROR THEN

243: p_count => x_msg_count,
244: p_data => x_msg_data);
245:
246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO create_merge_batch;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get(
251: p_encoded => FND_API.G_FALSE,

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245:
246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO create_merge_batch;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get(
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data);

Line 251: p_encoded => FND_API.G_FALSE,

247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO create_merge_batch;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get(
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data);
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data);
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO create_merge_batch;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: FND_MSG_PUB.Count_And_Get(
259: p_encoded => FND_API.G_FALSE,

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: p_data => x_msg_data);
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO create_merge_batch;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: FND_MSG_PUB.Count_And_Get(
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data);

Line 259: p_encoded => FND_API.G_FALSE,

255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO create_merge_batch;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: FND_MSG_PUB.Count_And_Get(
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data);
262:
263: WHEN OTHERS THEN

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

262:
263: WHEN OTHERS THEN
264:
265: ROLLBACK TO create_merge_batch;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
270: FND_MSG_PUB.ADD;

Line 273: p_encoded => FND_API.G_FALSE,

269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
270: FND_MSG_PUB.ADD;
271:
272: FND_MSG_PUB.Count_And_Get(
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data);
276:
277: END create_merge_batch;