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_MESSAGE

Line 202: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

198:
199: WHEN OTHERS THEN
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,

Line 203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

199: WHEN OTHERS THEN
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,

Line 571: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

567:
568: WHEN OTHERS THEN
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,

Line 572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

568: WHEN OTHERS THEN
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,

Line 612: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

608: l_effective_start_date := p_location_profile_rec.effective_start_date;
609: l_validation_sst_flag := p_location_profile_rec.validation_sst_flag;
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;

Line 613: FND_MESSAGE.SET_TOKEN('COLUMN' ,'LOCATION_ID');

609: l_validation_sst_flag := p_location_profile_rec.validation_sst_flag;
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:

Line 620: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

616: END IF;
617:
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;

Line 621: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ACTUAL_CONTENT_SOURCE');

617:
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:

Line 627: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
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;

Line 628: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');

624: END IF;
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:

Line 634: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

630: RAISE FND_API.G_EXC_ERROR;
631: END IF;
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;

Line 635: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');

631: END IF;
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

Line 641: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

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
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;

Line 642: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ACTUAL_CONTENT_SOURCE');

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
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:

Line 648: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

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
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;

Line 649: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');

645: END IF;
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:

Line 655: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

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
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;

Line 656: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');

652: END IF;
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;

Line 671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668:
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:

Line 672: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

668:
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 (

Line 704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

700: WHERE location_profile_id = p_location_profile_id;
701: EXCEPTION
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;

Line 705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

701: EXCEPTION
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

Line 710: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

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' );
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;

Line 711: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Location Profile' );

707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END;
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;

Line 712: FND_MESSAGE.SET_TOKEN( 'VALUE', p_location_profile_id);

708: END;
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:

Line 726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723:
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;

Line 727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

723:
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:

Line 785: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

781: WHERE location_profile_id = p_location_profile_id);
782: EXCEPTION
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;

Line 786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

782: EXCEPTION
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

Line 791: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

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' );
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;

Line 792: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Location Profile' );

788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
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;

Line 793: FND_MESSAGE.SET_TOKEN( 'VALUE', p_location_profile_id);

789: END;
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:

Line 807: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804:
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;

Line 808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

804:
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: