DBA Data[Home] [Help]

APPS.HZ_PARTY_INFO_V2PUB dependencies on FND_MSG_PUB

Line 140: FND_MSG_PUB.ADD;

136: WHERE CREDIT_RATING_ID = p_credit_rating_rec.credit_rating_id;
137:
138: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
139: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
140: FND_MSG_PUB.ADD;
141: RAISE FND_API.G_EXC_ERROR;
142:
143: EXCEPTION
144: WHEN NO_DATA_FOUND THEN

Line 339: FND_MSG_PUB.ADD;

335: )
336: THEN
337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
338: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 350: FND_MSG_PUB.ADD;

346: WHEN NO_DATA_FOUND THEN
347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');
349: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;
352: END;
353:
354: -- validate person interest record

Line 538: FND_MSG_PUB.initialize;

534: SAVEPOINT create_credit_rating;
535:
536: --Initialize message list if p_init_msg_list is set to TRUE.
537: IF FND_API.to_Boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: --Initialize API return status to success.
542: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 581: FND_MSG_PUB.Count_And_Get(

577: END IF;
578:
579:
580: --Standard call to get message count and if count is 1, get message info.
581: FND_MSG_PUB.Count_And_Get(
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data);
585:

Line 590: FND_MSG_PUB.Count_And_Get(

586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: ROLLBACK TO create_credit_rating;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data);
594:

Line 598: FND_MSG_PUB.Count_And_Get(

594:
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO create_credit_rating;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.Count_And_Get(
599: p_encoded => FND_API.G_FALSE,
600: p_count => x_msg_count,
601: p_data => x_msg_data);
602:

Line 608: FND_MSG_PUB.ADD;

604: ROLLBACK TO create_credit_rating;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609: FND_MSG_PUB.Count_And_Get(
610: p_encoded => FND_API.G_FALSE,
611: p_count => x_msg_count,
612: p_data => x_msg_data);

Line 609: FND_MSG_PUB.Count_And_Get(

605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609: FND_MSG_PUB.Count_And_Get(
610: p_encoded => FND_API.G_FALSE,
611: p_count => x_msg_count,
612: p_data => x_msg_data);
613:

Line 668: FND_MSG_PUB.initialize;

664: SAVEPOINT update_credit_rating;
665:
666: --Initialize message list if p_init_msg_list is set to TRUE.
667: IF FND_API.to_Boolean(p_init_msg_list) THEN
668: FND_MSG_PUB.initialize;
669: END IF;
670:
671: --Initialize API return status to success.
672: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 713: FND_MSG_PUB.Count_And_Get(

709: END IF;
710: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
711:
712: --Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get(
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);
717:

Line 723: FND_MSG_PUB.Count_And_Get(

719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO update_credit_rating;
721: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:

Line 732: FND_MSG_PUB.Count_And_Get(

728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO update_credit_rating;
730: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_msg_count,
735: p_data => x_msg_data);
736:

Line 743: FND_MSG_PUB.ADD;

739: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data);

Line 744: FND_MSG_PUB.Count_And_Get(

740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data);
748:

Line 798: FND_MSG_PUB.initialize;

794: BEGIN
795:
796: --Initialize message list if p_init_msg_list is set to TRUE.
797: IF FND_API.to_Boolean(p_init_msg_list) THEN
798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: --Initialize API return status to success.
802: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 809: FND_MSG_PUB.ADD;

805: IF p_credit_rating_id IS NULL OR
806: p_credit_rating_id = FND_API.G_MISS_NUM THEN
807: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
808: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_rating_id' );
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813: -- The x_credit_rating_rec.credit_rating_id must be initiated to p_credit_rating_id

Line 916: FND_MSG_PUB.Count_And_Get(

912: x_actual_content_source => x_credit_rating_rec.actual_content_source
913: );
914:
915: --Standard call to get message count and if count is 1, get message info.
916: FND_MSG_PUB.Count_And_Get(
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data );
920:

Line 925: FND_MSG_PUB.Count_And_Get(

921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924:
925: FND_MSG_PUB.Count_And_Get(
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 932: FND_MSG_PUB.Count_And_Get(

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

Line 942: FND_MSG_PUB.ADD;

938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939:
940: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;
943:
944: FND_MSG_PUB.Count_And_Get(
945: p_encoded => FND_API.G_FALSE,
946: p_count => x_msg_count,

Line 944: FND_MSG_PUB.Count_And_Get(

940: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;
943:
944: FND_MSG_PUB.Count_And_Get(
945: p_encoded => FND_API.G_FALSE,
946: p_count => x_msg_count,
947: p_data => x_msg_data );
948: