eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_LOCATION_PROFILE_PVT dependencies on FND_MSG_PUB

Line 112: FND_MSG_PUB.initialize;

108: savepoint create_location_profile_pub;
109:
110: -- initialize message list if p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean(p_init_msg_list) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114:
115: --Initialize API return status to success.
116: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 186: FND_MSG_PUB.Count_And_Get(

182:
183: WHEN FND_API.G_EXC_ERROR THEN
184: ROLLBACK TO create_location_profile_pub;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: FND_MSG_PUB.Count_And_Get(
187: p_encoded => FND_API.G_FALSE,
188: p_count => x_msg_count,
189: p_data => x_msg_data);
190:

Line 194: FND_MSG_PUB.Count_And_Get(

190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ROLLBACK TO create_location_profile_pub;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get(
195: p_encoded => FND_API.G_FALSE,
196: p_count => x_msg_count,
197: p_data => x_msg_data);
198:

Line 204: FND_MSG_PUB.ADD;

200: ROLLBACK TO create_location_profile_pub;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
204: FND_MSG_PUB.ADD;
205: FND_MSG_PUB.Count_And_Get(
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data);

Line 205: FND_MSG_PUB.Count_And_Get(

201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
204: FND_MSG_PUB.ADD;
205: FND_MSG_PUB.Count_And_Get(
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data);
209: END create_location_profile;

Line 266: FND_MSG_PUB.initialize;

262: savepoint update_location_profile_pub;
263:
264: -- initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean(p_init_msg_list) THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: --Initialize API return status to success.
270: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 555: FND_MSG_PUB.Count_And_Get(

551: EXCEPTION
552: WHEN FND_API.G_EXC_ERROR THEN
553: ROLLBACK TO update_location_profile_pub;
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: FND_MSG_PUB.Count_And_Get(
556: p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count,
558: p_data => x_msg_data);
559:

Line 563: FND_MSG_PUB.Count_And_Get(

559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO update_location_profile_pub;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MSG_PUB.Count_And_Get(
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_msg_count,
566: p_data => x_msg_data);
567:

Line 573: FND_MSG_PUB.ADD;

569: ROLLBACK TO update_location_profile_pub;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
573: FND_MSG_PUB.ADD;
574: FND_MSG_PUB.Count_And_Get(
575: p_encoded => FND_API.G_FALSE,
576: p_count => x_msg_count,
577: p_data => x_msg_data);

Line 574: FND_MSG_PUB.Count_And_Get(

570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
573: FND_MSG_PUB.ADD;
574: FND_MSG_PUB.Count_And_Get(
575: p_encoded => FND_API.G_FALSE,
576: p_count => x_msg_count,
577: p_data => x_msg_data);
578: END update_location_profile;

Line 614: FND_MSG_PUB.ADD;

610:
611: IF(l_location_id IS NULL OR l_location_id = FND_API.G_MISS_NUM) THEN
612: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
613: FND_MESSAGE.SET_TOKEN('COLUMN' ,'LOCATION_ID');
614: FND_MSG_PUB.ADD;
615: RAISE FND_API.G_EXC_ERROR;
616: END IF;
617:
618: IF (p_create_update_flag = 'U') THEN

Line 622: FND_MSG_PUB.ADD;

618: IF (p_create_update_flag = 'U') THEN
619: IF(l_actual_content_source = FND_API.G_MISS_CHAR) THEN
620: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
621: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ACTUAL_CONTENT_SOURCE');
622: FND_MSG_PUB.ADD;
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625:
626: IF(l_address1 = FND_API.G_MISS_CHAR) THEN

Line 629: FND_MSG_PUB.ADD;

625:
626: IF(l_address1 = FND_API.G_MISS_CHAR) THEN
627: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
628: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');
629: FND_MSG_PUB.ADD;
630: RAISE FND_API.G_EXC_ERROR;
631: END IF;
632:
633: IF(l_country = FND_API.G_MISS_CHAR) THEN

Line 636: FND_MSG_PUB.ADD;

632:
633: IF(l_country = FND_API.G_MISS_CHAR) THEN
634: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
635: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');
636: FND_MSG_PUB.ADD;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639: ELSIF (p_create_update_flag = 'C') THEN
640: IF(l_actual_content_source IS NULL OR l_actual_content_source = FND_API.G_MISS_CHAR) THEN

Line 643: FND_MSG_PUB.ADD;

639: ELSIF (p_create_update_flag = 'C') THEN
640: IF(l_actual_content_source IS NULL OR l_actual_content_source = FND_API.G_MISS_CHAR) THEN
641: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
642: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ACTUAL_CONTENT_SOURCE');
643: FND_MSG_PUB.ADD;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646:
647: IF(l_address1 IS NULL OR l_address1 = FND_API.G_MISS_CHAR) THEN

Line 650: FND_MSG_PUB.ADD;

646:
647: IF(l_address1 IS NULL OR l_address1 = FND_API.G_MISS_CHAR) THEN
648: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
649: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: IF(l_country IS NULL OR l_country = FND_API.G_MISS_CHAR) THEN

Line 657: FND_MSG_PUB.ADD;

653:
654: IF(l_country IS NULL OR l_country = FND_API.G_MISS_CHAR) THEN
655: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
656: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');
657: FND_MSG_PUB.ADD;
658: RAISE FND_API.G_EXC_ERROR;
659: END IF;
660: END IF;
661:

Line 673: FND_MSG_PUB.ADD;

669: WHEN OTHERS THEN
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
672: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
673: FND_MSG_PUB.ADD;
674: END validate_mandatory_column;
675:
676: PROCEDURE set_effective_end_date (
677: p_location_profile_id IN NUMBER

Line 706: FND_MSG_PUB.ADD;

702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END;
709: ELSE
710: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

Line 713: FND_MSG_PUB.ADD;

709: ELSE
710: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
711: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Location Profile' );
712: FND_MESSAGE.SET_TOKEN( 'VALUE', p_location_profile_id);
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: EXCEPTION

Line 728: FND_MSG_PUB.ADD;

724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
728: FND_MSG_PUB.ADD;
729:
730: END set_effective_end_date;
731:
732: --

Line 787: FND_MSG_PUB.ADD;

783: WHEN OTHERS THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790: ELSE
791: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

Line 794: FND_MSG_PUB.ADD;

790: ELSE
791: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
792: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Location Profile' );
793: FND_MESSAGE.SET_TOKEN( 'VALUE', p_location_profile_id);
794: FND_MSG_PUB.ADD;
795: RAISE FND_API.G_EXC_ERROR;
796: END IF;
797:
798: EXCEPTION

Line 809: FND_MSG_PUB.ADD;

805: WHEN OTHERS THEN
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
809: FND_MSG_PUB.ADD;
810:
811: END set_validation_status_code;
812:
813: PROCEDURE log(

Line 835: FND_MSG_PUB.Reset;

831: FUNCTION logerror(SQLERRM VARCHAR2 DEFAULT NULL)
832: RETURN VARCHAR2 IS
833: l_msg_data VARCHAR2(2000);
834: BEGIN
835: FND_MSG_PUB.Reset;
836:
837: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
838: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
839: END LOOP;

Line 837: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

833: l_msg_data VARCHAR2(2000);
834: BEGIN
835: FND_MSG_PUB.Reset;
836:
837: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
838: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
839: END LOOP;
840: IF (SQLERRM IS NOT NULL) THEN
841: l_msg_data := l_msg_data || SQLERRM;

Line 838: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

834: BEGIN
835: FND_MSG_PUB.Reset;
836:
837: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
838: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
839: END LOOP;
840: IF (SQLERRM IS NOT NULL) THEN
841: l_msg_data := l_msg_data || SQLERRM;
842: END IF;