DBA Data[Home] [Help]

APPS.HZ_RELATIONSHIP_TYPE_V2PUB dependencies on FND_MSG_PUB

Line 138: FND_MSG_PUB.ADD;

134: WHERE RELATIONSHIP_TYPE_ID = l_relationship_type_id;
135:
136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
137: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type_id');
138: FND_MSG_PUB.ADD;
139: RAISE FND_API.G_EXC_ERROR;
140:
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN

Line 533: FND_MSG_PUB.ADD;

529: )
530: THEN
531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
532: FND_MESSAGE.SET_TOKEN('TABLE', 'relationship_type_id');
533: FND_MSG_PUB.ADD;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
537: p_object_version_number := NVL(l_object_version_number, 1) + 1;

Line 543: FND_MSG_PUB.ADD;

539: EXCEPTION WHEN NO_DATA_FOUND THEN
540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
541: FND_MESSAGE.SET_TOKEN('RECORD', 'relationship_type');
542: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_relationship_type_rec.relationship_type_id),'null'));
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END;
546:
547: /* Bug Fix : 2644154. Making the create_party_flag = 'Y' for the

Line 691: FND_MSG_PUB.initialize;

687: SAVEPOINT create_relationship_type;
688:
689: -- Initialize message list if p_init_msg_list is set to TRUE.
690: IF FND_API.to_Boolean(p_init_msg_list) THEN
691: FND_MSG_PUB.initialize;
692: END IF;
693:
694: -- Initialize API return status to success.
695: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 710: FND_MSG_PUB.Count_And_Get(

706: RAISE FND_API.G_EXC_ERROR;
707: END IF;
708:
709: -- Standard call to get message count and if count is 1, get message info.
710: FND_MSG_PUB.Count_And_Get(
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data);
714:

Line 719: FND_MSG_PUB.Count_And_Get(

715: EXCEPTION
716: WHEN FND_API.G_EXC_ERROR THEN
717: ROLLBACK TO create_relationship_type;
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: FND_MSG_PUB.Count_And_Get(
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_msg_count,
722: p_data => x_msg_data);
723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 726: FND_MSG_PUB.Count_And_Get(

722: p_data => x_msg_data);
723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
724: ROLLBACK TO create_relationship_type;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: FND_MSG_PUB.Count_And_Get(
727: p_encoded => FND_API.G_FALSE,
728: p_count => x_msg_count,
729: p_data => x_msg_data);
730:

Line 736: FND_MSG_PUB.ADD;

732: ROLLBACK TO create_relationship_type;
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data);

Line 737: FND_MSG_PUB.Count_And_Get(

733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data);
741:

Line 794: FND_MSG_PUB.initialize;

790: SAVEPOINT update_relationship_type;
791:
792: -- Initialize message list if p_init_msg_list is set to TRUE.
793: IF FND_API.to_Boolean(p_init_msg_list) THEN
794: FND_MSG_PUB.initialize;
795: END IF;
796:
797: -- Initialize API return status to success.
798: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 807: FND_MSG_PUB.Count_And_Get(

803: p_object_version_number,
804: x_return_status);
805:
806: -- Standard call to get message count and if count is 1, get message info.
807: FND_MSG_PUB.Count_And_Get(
808: p_encoded => FND_API.G_FALSE,
809: p_count => x_msg_count,
810: p_data => x_msg_data);
811:

Line 816: FND_MSG_PUB.Count_And_Get(

812: EXCEPTION
813: WHEN FND_API.G_EXC_ERROR THEN
814: ROLLBACK TO update_relationship_type;
815: x_return_status := FND_API.G_RET_STS_ERROR;
816: FND_MSG_PUB.Count_And_Get(
817: p_encoded => FND_API.G_FALSE,
818: p_count => x_msg_count,
819: p_data => x_msg_data);
820:

Line 824: FND_MSG_PUB.Count_And_Get(

820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO update_relationship_type;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: FND_MSG_PUB.Count_And_Get(
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828: WHEN OTHERS THEN

Line 833: FND_MSG_PUB.ADD;

829: ROLLBACK TO update_relationship_type;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get(
835: p_encoded => FND_API.G_FALSE,
836: p_count => x_msg_count,
837: p_data => x_msg_data);

Line 834: FND_MSG_PUB.Count_And_Get(

830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get(
835: p_encoded => FND_API.G_FALSE,
836: p_count => x_msg_count,
837: p_data => x_msg_data);
838: