eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_BATCH_SUMMARY_V2PUB dependencies on FND_API

Line 19: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

15: *
16: * ARGUMENTS
17: * IN:
18: * p_init_msg_list Initialize message stack if it is set to
19: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
20: * p_batch_name Import batch name.
21: * p_description Import batch description.
22: * p_original_system Original system from which data brought into this batch
23: * p_load_type Load type of the data, e.g. DNB, CSV

Line 29: * be FND_API.G_RET_STS_SUCCESS (success),

25: * IN/OUT:
26: * OUT:
27: * x_batch_id Batch ID generated by system.
28: * x_return_status Return status after the call. The status can
29: * be FND_API.G_RET_STS_SUCCESS (success),
30: * FND_API.G_RET_STS_ERROR (error),
31: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
32: * x_msg_count Number of messages in message stack.
33: * x_msg_data Message text if x_msg_count is 1.

Line 30: * FND_API.G_RET_STS_ERROR (error),

26: * OUT:
27: * x_batch_id Batch ID generated by system.
28: * x_return_status Return status after the call. The status can
29: * be FND_API.G_RET_STS_SUCCESS (success),
30: * FND_API.G_RET_STS_ERROR (error),
31: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
32: * x_msg_count Number of messages in message stack.
33: * x_msg_data Message text if x_msg_count is 1.
34: *

Line 31: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

27: * x_batch_id Batch ID generated by system.
28: * x_return_status Return status after the call. The status can
29: * be FND_API.G_RET_STS_SUCCESS (success),
30: * FND_API.G_RET_STS_ERROR (error),
31: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
32: * x_msg_count Number of messages in message stack.
33: * x_msg_data Message text if x_msg_count is 1.
34: *
35: * NOTES

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

40: *
41: */
42:
43: PROCEDURE create_import_batch (
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_batch_name IN VARCHAR2,
46: p_description IN VARCHAR2,
47: p_original_system IN VARCHAR2,
48: p_load_type IN VARCHAR2 := NULL,

Line 69: IF FND_API.to_Boolean(p_init_msg_list) THEN

65:
66: -- Debug info.
67:
68: -- initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean(p_init_msg_list) THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: -- initialize API return status to success.

Line 74: x_return_status := FND_API.G_RET_STS_SUCCESS;

70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: -- initialize API return status to success.
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75:
76: ----------------
77: -- do validation
78: ----------------

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

120: FND_MESSAGE.SET_TOKEN('FK','orig_system');
121: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END;
126:
127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
128: RAISE FND_API.G_EXC_ERROR;

Line 127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END;
126:
127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: --------------------------------------------

Line 128: RAISE FND_API.G_EXC_ERROR;

124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END;
126:
127: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: --------------------------------------------
132: -- insert the record with generated batch id

Line 204: p_encoded => fnd_api.g_false,

200:
201:
202: -- standard call to get message count and if count is 1, get message info.
203: fnd_msg_pub.count_and_get(
204: p_encoded => fnd_api.g_false,
205: p_count => x_msg_count,
206: p_data => x_msg_data);
207:
208: -- Debug info.

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209:
210: -- Check if API is called in debug mode. If yes, disable debug.
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO create_import_batch;
215:
216: x_return_status := fnd_api.g_ret_sts_error;
217:

Line 216: x_return_status := fnd_api.g_ret_sts_error;

212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO create_import_batch;
215:
216: x_return_status := fnd_api.g_ret_sts_error;
217:
218: fnd_msg_pub.count_and_get(
219: p_encoded => fnd_api.g_false,
220: p_count => x_msg_count,

Line 219: p_encoded => fnd_api.g_false,

215:
216: x_return_status := fnd_api.g_ret_sts_error;
217:
218: fnd_msg_pub.count_and_get(
219: p_encoded => fnd_api.g_false,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222:
223: -- Debug info.

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

223: -- Debug info.
224:
225: -- Check if API is called in debug mode. If yes, disable debug.
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO create_import_batch;
229:
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231:

Line 230: x_return_status := fnd_api.g_ret_sts_unexp_error;

226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO create_import_batch;
229:
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231:
232: fnd_msg_pub.count_and_get(
233: p_encoded => fnd_api.g_false,
234: p_count => x_msg_count,

Line 233: p_encoded => fnd_api.g_false,

229:
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231:
232: fnd_msg_pub.count_and_get(
233: p_encoded => fnd_api.g_false,
234: p_count => x_msg_count,
235: p_data => x_msg_data);
236:
237: -- Debug info.

Line 244: x_return_status := fnd_api.g_ret_sts_unexp_error;

240:
241: WHEN OTHERS THEN
242: ROLLBACK TO create_import_batch;
243:
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:
246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
247: fnd_message.set_token('ERROR',SQLERRM);
248: fnd_msg_pub.add;

Line 251: p_encoded => fnd_api.g_false,

247: fnd_message.set_token('ERROR',SQLERRM);
248: fnd_msg_pub.add;
249:
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: -- Debug info.

Line 273: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

269: *
270: * ARGUMENTS
271: * IN:
272: * p_init_msg_list Initialize message stack if it is set to
273: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
274: * p_batch_id ID of the batch you want to activate for import processing
275: * IN/OUT:
276: * OUT:
277: * x_return_status Return status after the call. The status can

Line 278: * be FND_API.G_RET_STS_SUCCESS (success),

274: * p_batch_id ID of the batch you want to activate for import processing
275: * IN/OUT:
276: * OUT:
277: * x_return_status Return status after the call. The status can
278: * be FND_API.G_RET_STS_SUCCESS (success),
279: * FND_API.G_RET_STS_ERROR (error),
280: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
281: * x_msg_count Number of messages in message stack.
282: * x_msg_data Message text if x_msg_count is 1.

Line 279: * FND_API.G_RET_STS_ERROR (error),

275: * IN/OUT:
276: * OUT:
277: * x_return_status Return status after the call. The status can
278: * be FND_API.G_RET_STS_SUCCESS (success),
279: * FND_API.G_RET_STS_ERROR (error),
280: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
281: * x_msg_count Number of messages in message stack.
282: * x_msg_data Message text if x_msg_count is 1.
283: *

Line 280: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

276: * OUT:
277: * x_return_status Return status after the call. The status can
278: * be FND_API.G_RET_STS_SUCCESS (success),
279: * FND_API.G_RET_STS_ERROR (error),
280: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
281: * x_msg_count Number of messages in message stack.
282: * x_msg_data Message text if x_msg_count is 1.
283: *
284: * NOTES

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

289: *
290: */
291:
292: PROCEDURE activate_batch (
293: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
294: p_batch_id IN NUMBER,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2

Line 316: IF FND_API.to_Boolean(p_init_msg_list) THEN

312:
313: -- Debug info.
314:
315: -- initialize message list if p_init_msg_list is set to TRUE.
316: IF FND_API.to_Boolean(p_init_msg_list) THEN
317: FND_MSG_PUB.initialize;
318: END IF;
319:
320: -- initialize API return status to success.

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317: FND_MSG_PUB.initialize;
318: END IF;
319:
320: -- initialize API return status to success.
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: ----------------
324: -- do validation
325: ----------------

Line 350: x_return_status := fnd_api.g_ret_sts_error;

346: fnd_message.set_token('FK', 'p_batch_id');
347: fnd_message.set_token('COLUMN', 'batch_id');
348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');
349: fnd_msg_pub.add;
350: x_return_status := fnd_api.g_ret_sts_error;
351: END;
352:
353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
354: RAISE FND_API.G_EXC_ERROR;

Line 353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

349: fnd_msg_pub.add;
350: x_return_status := fnd_api.g_ret_sts_error;
351: END;
352:
353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: -- batch id must be a valid batch for processing

Line 354: RAISE FND_API.G_EXC_ERROR;

350: x_return_status := fnd_api.g_ret_sts_error;
351: END;
352:
353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: -- batch id must be a valid batch for processing
358: BEGIN

Line 369: x_return_status := fnd_api.g_ret_sts_error;

365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN
367: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');
368: fnd_msg_pub.add;
369: x_return_status := fnd_api.g_ret_sts_error;
370: END;
371:
372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: RAISE FND_API.G_EXC_ERROR;

Line 372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

368: fnd_msg_pub.add;
369: x_return_status := fnd_api.g_ret_sts_error;
370: END;
371:
372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375:
376: ---------------------------------

Line 373: RAISE FND_API.G_EXC_ERROR;

369: x_return_status := fnd_api.g_ret_sts_error;
370: END;
371:
372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375:
376: ---------------------------------
377: -- update the batch summary table

Line 398: p_encoded => fnd_api.g_false,

394: execute immediate l_pre_count_stat using p_batch_id, l_original_system;
395:
396: -- standard call to get message count and if count is 1, get message info.
397: fnd_msg_pub.count_and_get(
398: p_encoded => fnd_api.g_false,
399: p_count => x_msg_count,
400: p_data => x_msg_data);
401:
402: EXCEPTION

Line 403: WHEN FND_API.G_EXC_ERROR THEN

399: p_count => x_msg_count,
400: p_data => x_msg_data);
401:
402: EXCEPTION
403: WHEN FND_API.G_EXC_ERROR THEN
404: ROLLBACK TO activate_batch;
405:
406: x_return_status := fnd_api.g_ret_sts_error;
407:

Line 406: x_return_status := fnd_api.g_ret_sts_error;

402: EXCEPTION
403: WHEN FND_API.G_EXC_ERROR THEN
404: ROLLBACK TO activate_batch;
405:
406: x_return_status := fnd_api.g_ret_sts_error;
407:
408: fnd_msg_pub.count_and_get(
409: p_encoded => fnd_api.g_false,
410: p_count => x_msg_count,

Line 409: p_encoded => fnd_api.g_false,

405:
406: x_return_status := fnd_api.g_ret_sts_error;
407:
408: fnd_msg_pub.count_and_get(
409: p_encoded => fnd_api.g_false,
410: p_count => x_msg_count,
411: p_data => x_msg_data);
412:
413: -- Debug info.

Line 417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

413: -- Debug info.
414:
415: -- Check if API is called in debug mode. If yes, disable debug.
416:
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: ROLLBACK TO activate_batch;
419:
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421:

Line 420: x_return_status := fnd_api.g_ret_sts_unexp_error;

416:
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: ROLLBACK TO activate_batch;
419:
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421:
422: fnd_msg_pub.count_and_get(
423: p_encoded => fnd_api.g_false,
424: p_count => x_msg_count,

Line 423: p_encoded => fnd_api.g_false,

419:
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421:
422: fnd_msg_pub.count_and_get(
423: p_encoded => fnd_api.g_false,
424: p_count => x_msg_count,
425: p_data => x_msg_data);
426:
427: -- Debug info.

Line 434: x_return_status := fnd_api.g_ret_sts_unexp_error;

430:
431: WHEN OTHERS THEN
432: ROLLBACK TO activate_batch;
433:
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435:
436: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
437: fnd_message.set_token('ERROR',SQLERRM);
438: fnd_msg_pub.add;

Line 441: p_encoded => fnd_api.g_false,

437: fnd_message.set_token('ERROR',SQLERRM);
438: fnd_msg_pub.add;
439:
440: fnd_msg_pub.count_and_get(
441: p_encoded => fnd_api.g_false,
442: p_count => x_msg_count,
443: p_data => x_msg_data);
444:
445: -- Debug info.