DBA Data[Home] [Help]

APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on FND_MSG_PUB

Line 187: FND_MSG_PUB.ADD;

183: p_location_id = FND_API.G_MISS_NUM
184: THEN
185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:
191: -- checking whether this location is for Remit-To Address or not

Line 333: FND_MSG_PUB.ADD;

329: p_location_id = FND_API.G_MISS_NUM
330: THEN
331: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
332: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
333: FND_MSG_PUB.ADD;
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336:
337: BEGIN

Line 347: FND_MSG_PUB.ADD;

343: WHEN NO_DATA_FOUND THEN
344: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
345: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
346: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
347: FND_MSG_PUB.ADD;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: END;
350:
351: -- raise error if the update location profile option is turned off and

Line 359: FND_MSG_PUB.ADD;

355: l_date_validated IS NOT NULL AND
356: l_validation_status_code IS NOT NULL)
357: THEN
358: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');
359: FND_MSG_PUB.ADD;
360: RAISE fnd_api.g_exc_error;
361: END IF;
362:
363: -- checking whether this location is for Remit-To Address or not

Line 506: FND_MSG_PUB.initialize;

502: SAVEPOINT create_loc_assignment;
503:
504: -- initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean(p_init_msg_list) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: -- initialize API return status to success.
510: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 526: FND_MSG_PUB.Count_And_Get(

522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: -- standard call to get message count and if count is 1, get message info.
526: FND_MSG_PUB.Count_And_Get(
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:

Line 535: FND_MSG_PUB.Count_And_Get(

531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO create_loc_assignment;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_And_Get(
536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539:

Line 543: FND_MSG_PUB.Count_And_Get(

539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK TO create_loc_assignment;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get(
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count,
546: p_data => x_msg_data);
547:

Line 553: FND_MSG_PUB.ADD;

549: ROLLBACK TO create_loc_assignment;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
553: FND_MSG_PUB.ADD;
554: FND_MSG_PUB.Count_And_Get(
555: p_encoded => FND_API.G_FALSE,
556: p_count => x_msg_count,
557: p_data => x_msg_data);

Line 554: FND_MSG_PUB.Count_And_Get(

550: x_return_status := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
553: FND_MSG_PUB.ADD;
554: FND_MSG_PUB.Count_And_Get(
555: p_encoded => FND_API.G_FALSE,
556: p_count => x_msg_count,
557: p_data => x_msg_data);
558: WHEN OTHERS THEN

Line 563: FND_MSG_PUB.ADD;

559: ROLLBACK TO create_loc_assignment;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data);

Line 564: FND_MSG_PUB.Count_And_Get(

560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data);
568:

Line 694: FND_MSG_PUB.initialize;

690: SAVEPOINT update_loc_assignment;
691:
692: -- initialize message list if p_init_msg_list is set to TRUE.
693: IF FND_API.to_Boolean(p_init_msg_list) THEN
694: FND_MSG_PUB.initialize;
695: END IF;
696:
697: -- initialize API return status to success.
698: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 714: FND_MSG_PUB.Count_And_Get(

710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712:
713: -- standard call to get message count and if count is 1, get message info.
714: FND_MSG_PUB.Count_And_Get(
715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data);
718: EXCEPTION

Line 722: FND_MSG_PUB.Count_And_Get(

718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO update_loc_assignment;
721: x_return_status := FND_API.G_RET_STS_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 730: FND_MSG_PUB.Count_And_Get(

726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO update_loc_assignment;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:

Line 740: FND_MSG_PUB.ADD;

736: ROLLBACK TO update_loc_assignment;
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: FND_MSG_PUB.Count_And_Get(
742: p_encoded => FND_API.G_FALSE,
743: p_count => x_msg_count,
744: p_data => x_msg_data);

Line 741: FND_MSG_PUB.Count_And_Get(

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

Line 751: FND_MSG_PUB.ADD;

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

Line 752: FND_MSG_PUB.Count_And_Get(

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

Line 815: FND_MSG_PUB.initialize;

811: SAVEPOINT update_loc_assignment;
812:
813: -- initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean(p_init_msg_list) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- initialize API return status to success.
819: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 835: FND_MSG_PUB.Count_And_Get(

831: RAISE FND_API.G_EXC_ERROR;
832: END IF;
833:
834: -- standard call to get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get(
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data);
839: EXCEPTION

Line 843: FND_MSG_PUB.Count_And_Get(

839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO update_loc_assignment;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: FND_MSG_PUB.Count_And_Get(
844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data);
847:

Line 851: FND_MSG_PUB.Count_And_Get(

847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO update_loc_assignment;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855:

Line 861: FND_MSG_PUB.ADD;

857: ROLLBACK TO update_loc_assignment;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(
863: p_encoded => FND_API.G_FALSE,
864: p_count => x_msg_count,
865: p_data => x_msg_data);

Line 862: FND_MSG_PUB.Count_And_Get(

858: x_return_status := FND_API.G_RET_STS_ERROR;
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(
863: p_encoded => FND_API.G_FALSE,
864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:

Line 872: FND_MSG_PUB.ADD;

868: ROLLBACK TO update_loc_assignment;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_msg_count,
876: p_data => x_msg_data);

Line 873: FND_MSG_PUB.Count_And_Get(

869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_msg_count,
876: p_data => x_msg_data);
877: