DBA Data[Home] [Help]

APPS.HZ_IMP_BATCH_SUMMARY_V2PUB dependencies on FND_MSG_PUB

Line 70: FND_MSG_PUB.initialize;

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.
74: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 123: FND_MSG_PUB.ADD;

119: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
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

Line 203: fnd_msg_pub.count_and_get(

199:
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:

Line 218: fnd_msg_pub.count_and_get(

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,
221: p_data => x_msg_data);
222:

Line 232: fnd_msg_pub.count_and_get(

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,
235: p_data => x_msg_data);
236:

Line 248: fnd_msg_pub.add;

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;
249:
250: fnd_msg_pub.count_and_get(
251: p_encoded => fnd_api.g_false,
252: p_count => x_msg_count,

Line 250: fnd_msg_pub.count_and_get(

246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
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:

Line 317: FND_MSG_PUB.initialize;

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.
321: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 349: fnd_msg_pub.add;

345: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
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

Line 368: fnd_msg_pub.add;

364:
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

Line 397: fnd_msg_pub.count_and_get(

393: -- use dynamic sql to avoid compilation error in 8i
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:

Line 408: fnd_msg_pub.count_and_get(

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,
411: p_data => x_msg_data);
412:

Line 422: fnd_msg_pub.count_and_get(

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,
425: p_data => x_msg_data);
426:

Line 438: fnd_msg_pub.add;

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;
439:
440: fnd_msg_pub.count_and_get(
441: p_encoded => fnd_api.g_false,
442: p_count => x_msg_count,

Line 440: fnd_msg_pub.count_and_get(

436: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
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: