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 335: FND_MSG_PUB.ADD;

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

Line 349: FND_MSG_PUB.ADD;

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

Line 361: FND_MSG_PUB.ADD;

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

Line 432: l_message_count := fnd_msg_pub.count_msg();

428: ELSE
429: -- Below code will execute only if there is no record in hz_loc_assignments table
430: -- process_gnr will process the GNR and return success even if there is an error
431: -- in the validation.
432: l_message_count := fnd_msg_pub.count_msg();
433: HZ_GNR_PUB.process_gnr (
434: p_location_table_name => 'HZ_LOCATIONS',
435: p_location_id => p_location_id,
436: p_call_type => 'U',

Line 446: l_message_count_new := fnd_msg_pub.count_msg();

442: --Bug9671252
443: --When Address Validation Profile value is set NO
444: --then Process_GNR API generated messages need to be deleted.
445: IF p_do_addr_val = 'N' THEN
446: l_message_count_new := fnd_msg_pub.count_msg();
447: IF (l_message_count_new > l_message_count) THEN
448: FOR i IN REVERSE (l_message_count + 1)..l_message_count_new LOOP
449: fnd_msg_pub.delete_msg(i);
450: END LOOP;

Line 449: fnd_msg_pub.delete_msg(i);

445: IF p_do_addr_val = 'N' THEN
446: l_message_count_new := fnd_msg_pub.count_msg();
447: IF (l_message_count_new > l_message_count) THEN
448: FOR i IN REVERSE (l_message_count + 1)..l_message_count_new LOOP
449: fnd_msg_pub.delete_msg(i);
450: END LOOP;
451: END IF;
452: END IF;
453:

Line 521: FND_MSG_PUB.initialize;

517: SAVEPOINT create_loc_assignment;
518:
519: -- initialize message list if p_init_msg_list is set to TRUE.
520: IF FND_API.to_Boolean(p_init_msg_list) THEN
521: FND_MSG_PUB.initialize;
522: END IF;
523:
524: -- initialize API return status to success.
525: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 541: FND_MSG_PUB.Count_And_Get(

537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: -- standard call to get message count and if count is 1, get message info.
541: FND_MSG_PUB.Count_And_Get(
542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,
544: p_data => x_msg_data);
545:

Line 550: FND_MSG_PUB.Count_And_Get(

546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO create_loc_assignment;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(
551: p_encoded => FND_API.G_FALSE,
552: p_count => x_msg_count,
553: p_data => x_msg_data);
554:

Line 558: FND_MSG_PUB.Count_And_Get(

554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO create_loc_assignment;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: FND_MSG_PUB.Count_And_Get(
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data);
562:

Line 568: FND_MSG_PUB.ADD;

564: ROLLBACK TO create_loc_assignment;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);

Line 569: FND_MSG_PUB.Count_And_Get(

565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573: WHEN OTHERS THEN

Line 578: FND_MSG_PUB.ADD;

574: ROLLBACK TO create_loc_assignment;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(
580: p_encoded => FND_API.G_FALSE,
581: p_count => x_msg_count,
582: p_data => x_msg_data);

Line 579: FND_MSG_PUB.Count_And_Get(

575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(
580: p_encoded => FND_API.G_FALSE,
581: p_count => x_msg_count,
582: p_data => x_msg_data);
583:

Line 709: FND_MSG_PUB.initialize;

705: SAVEPOINT update_loc_assignment;
706:
707: -- initialize message list if p_init_msg_list is set to TRUE.
708: IF FND_API.to_Boolean(p_init_msg_list) THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711:
712: -- initialize API return status to success.
713: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 729: FND_MSG_PUB.Count_And_Get(

725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: -- standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data);
733: EXCEPTION

Line 737: FND_MSG_PUB.Count_And_Get(

733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO update_loc_assignment;
736: x_return_status := FND_API.G_RET_STS_ERROR;
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 745: FND_MSG_PUB.Count_And_Get(

741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO update_loc_assignment;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_And_Get(
746: p_encoded => FND_API.G_FALSE,
747: p_count => x_msg_count,
748: p_data => x_msg_data);
749:

Line 755: FND_MSG_PUB.ADD;

751: ROLLBACK TO update_loc_assignment;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
759: p_data => x_msg_data);

Line 756: FND_MSG_PUB.Count_And_Get(

752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
759: p_data => x_msg_data);
760:

Line 766: FND_MSG_PUB.ADD;

762: ROLLBACK TO update_loc_assignment;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data);

Line 767: FND_MSG_PUB.Count_And_Get(

763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data);
771:

Line 830: FND_MSG_PUB.initialize;

826: SAVEPOINT update_loc_assignment;
827:
828: -- initialize message list if p_init_msg_list is set to TRUE.
829: IF FND_API.to_Boolean(p_init_msg_list) THEN
830: FND_MSG_PUB.initialize;
831: END IF;
832:
833: -- initialize API return status to success.
834: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 850: FND_MSG_PUB.Count_And_Get(

846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
849: -- standard call to get message count and if count is 1, get message info.
850: FND_MSG_PUB.Count_And_Get(
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data);
854: EXCEPTION

Line 858: FND_MSG_PUB.Count_And_Get(

854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO update_loc_assignment;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MSG_PUB.Count_And_Get(
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data);
862:

Line 866: FND_MSG_PUB.Count_And_Get(

862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO update_loc_assignment;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: FND_MSG_PUB.Count_And_Get(
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data);
870:

Line 876: FND_MSG_PUB.ADD;

872: ROLLBACK TO update_loc_assignment;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
880: p_data => x_msg_data);

Line 877: FND_MSG_PUB.Count_And_Get(

873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
880: p_data => x_msg_data);
881:

Line 887: FND_MSG_PUB.ADD;

883: ROLLBACK TO update_loc_assignment;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_msg_count,
891: p_data => x_msg_data);

Line 888: FND_MSG_PUB.Count_And_Get(

884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_msg_count,
891: p_data => x_msg_data);
892: