DBA Data[Home] [Help]

APPS.HZ_CONTACT_PREFERENCE_V2PUB dependencies on FND_MSG_PUB

Line 297: FND_MSG_PUB.ADD;

293: p_object_version_number = l_object_version_number ) )
294: THEN
295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
296: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_contact_preferences');
297: FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:
301: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 307: FND_MSG_PUB.ADD;

303: EXCEPTION WHEN NO_DATA_FOUND THEN
304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
305: FND_MESSAGE.SET_TOKEN('RECORD', 'contact_preference');
306: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR( p_contact_preference_rec.contact_preference_id), 'null'));
307: FND_MSG_PUB.ADD;
308: RAISE FND_API.G_EXC_ERROR;
309: END;
310:
311: ----------------------------------------------

Line 443: FND_MSG_PUB.initialize;

439: END IF;
440:
441: --Initialize message list if p_init_msg_list is set to TRUE.
442: IF FND_API.to_Boolean(p_init_msg_list) THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446: --Initialize API return status to success.
447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 470: FND_MSG_PUB.Count_And_Get(

466: END IF;
467: END IF;
468:
469: --Standard call to get message count and if count is 1, get message info.
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474:

Line 495: FND_MSG_PUB.Count_And_Get(

491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN
493: ROLLBACK TO create_contact_preference_pub;
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: FND_MSG_PUB.Count_And_Get(
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data);
499:

Line 520: FND_MSG_PUB.Count_And_Get(

516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO create_contact_preference_pub;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: FND_MSG_PUB.Count_And_Get(
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data);
524:

Line 546: FND_MSG_PUB.ADD;

542: ROLLBACK TO create_contact_preference_pub;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547: FND_MSG_PUB.Count_And_Get(
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data);

Line 547: FND_MSG_PUB.Count_And_Get(

543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547: FND_MSG_PUB.Count_And_Get(
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data);
551:

Line 632: FND_MSG_PUB.initialize;

628: END IF;
629:
630: --Initialize message list if p_init_msg_list is set to TRUE.
631: IF FND_API.to_Boolean(p_init_msg_list) THEN
632: FND_MSG_PUB.initialize;
633: END IF;
634:
635: --Initialize API return status to success.
636: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 673: FND_MSG_PUB.Count_And_Get(

669: END IF;
670: END IF;
671:
672: --Standard call to get message count and if count is 1, get message info.
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => FND_API.G_FALSE,
675: p_count => x_msg_count,
676: p_data => x_msg_data);
677:

Line 698: FND_MSG_PUB.Count_And_Get(

694: EXCEPTION
695: WHEN FND_API.G_EXC_ERROR THEN
696: ROLLBACK TO update_contact_preference_pub;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MSG_PUB.Count_And_Get(
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data);
702:

Line 722: FND_MSG_PUB.Count_And_Get(

718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO update_contact_preference_pub;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: FND_MSG_PUB.Count_And_Get(
723: p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726:

Line 748: FND_MSG_PUB.ADD;

744: ROLLBACK TO update_contact_preference_pub;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
748: FND_MSG_PUB.ADD;
749: FND_MSG_PUB.Count_And_Get(
750: p_encoded => FND_API.G_FALSE,
751: p_count => x_msg_count,
752: p_data => x_msg_data);

Line 749: FND_MSG_PUB.Count_And_Get(

745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
748: FND_MSG_PUB.ADD;
749: FND_MSG_PUB.Count_And_Get(
750: p_encoded => FND_API.G_FALSE,
751: p_count => x_msg_count,
752: p_data => x_msg_data);
753:

Line 826: FND_MSG_PUB.initialize;

822: END IF;
823:
824: --Initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean(p_init_msg_list) THEN
826: FND_MSG_PUB.initialize;
827: END IF;
828:
829: --Initialize API return status to success.
830: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 837: FND_MSG_PUB.ADD;

833: IF p_contact_preference_id IS NULL OR
834: p_contact_preference_id = FND_API.G_MISS_NUM THEN
835: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
836: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_preference_id' );
837: FND_MSG_PUB.ADD;
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840:
841: x_contact_preference_rec.contact_preference_id := p_contact_preference_id;

Line 880: FND_MSG_PUB.Count_And_Get(

876: p_msg_level=>fnd_log.level_procedure);
877: END IF;
878:
879: --Standard call to get message count and if count is 1, get message info.
880: FND_MSG_PUB.Count_And_Get(
881: p_encoded => FND_API.G_FALSE,
882: p_count => x_msg_count,
883: p_data => x_msg_data );
884:

Line 906: FND_MSG_PUB.Count_And_Get(

902: EXCEPTION
903: WHEN FND_API.G_EXC_ERROR THEN
904: x_return_status := FND_API.G_RET_STS_ERROR;
905:
906: FND_MSG_PUB.Count_And_Get(
907: p_encoded => FND_API.G_FALSE,
908: p_count => x_msg_count,
909: p_data => x_msg_data );
910:

Line 930: FND_MSG_PUB.Count_And_Get(

926:
927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929:
930: FND_MSG_PUB.Count_And_Get(
931: p_encoded => FND_API.G_FALSE,
932: p_count => x_msg_count,
933: p_data => x_msg_data );
934:

Line 956: FND_MSG_PUB.ADD;

952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953:
954: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
955: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
956: FND_MSG_PUB.ADD;
957:
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,

Line 958: FND_MSG_PUB.Count_And_Get(

954: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
955: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
956: FND_MSG_PUB.ADD;
957:
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data );
962: