APPS.HZ_IMP_LOAD_PARTY_SITE_USE_PKG dependencies on FND_MSG_PUB

Line 350: FND_MSG_PUB.initialize;

346: END IF;
347:
348: savepoint process_insert_psu_pvt;
349:
350: FND_MSG_PUB.initialize;
351:
352: --Initialize API return status to success.
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:

Line 417: FND_MSG_PUB.ADD;

413: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(
419: p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,
421: p_data => x_msg_data);

Line 418: FND_MSG_PUB.Count_And_Get(

414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(
419: p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,
421: p_data => x_msg_data);
422:

Line 430: FND_MSG_PUB.ADD;

426: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count,
434: p_data => x_msg_data);

Line 431: FND_MSG_PUB.Count_And_Get(

427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count,
434: p_data => x_msg_data);
435:

Line 464: FND_MSG_PUB.initialize;

460: p_prefix=>l_debug_prefix,
461: p_msg_level=>fnd_log.level_procedure);
462: END IF;
463:
464: FND_MSG_PUB.initialize;
465:
466: --Initialize API return status to success.
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:

Line 490: FND_MSG_PUB.Count_And_Get(

486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO load_partysiteuses_pvt;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MSG_PUB.Count_And_Get(
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data);
494:

Line 502: FND_MSG_PUB.ADD;

498: FND_FILE.put_line(fnd_file.log, l_errm);
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);

Line 503: FND_MSG_PUB.Count_And_Get(

499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);
507:

Line 524: FND_MSG_PUB.ADD;

520: FND_FILE.put_line(fnd_file.log, l_errm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(
526: p_encoded => FND_API.G_FALSE,
527: p_count => x_msg_count,
528: p_data => x_msg_data);

Line 525: FND_MSG_PUB.Count_And_Get(

521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(
526: p_encoded => FND_API.G_FALSE,
527: p_count => x_msg_count,
528: p_data => x_msg_data);
529: