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_IMP_ADDRESS_VAL_PKG dependencies on FND_API

Line 627: RAISE FND_API.G_EXC_ERROR;

623: when others THEN
624: FND_FILE.put_line(fnd_file.log,'compare_treshhold: Aborting processing inboundxml for this batch');
625: FND_FILE.put_line(fnd_file.log,'compare_treshhold: p_value1,p_value2:-'||p_value1||'-'||p_value2);
626: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
627: RAISE FND_API.G_EXC_ERROR;
628: end;
629:
630: -----------------------------------------------------------------------
631: -- This procedure will be called by xml gateway through mapcode,

Line 676: RAISE FND_API.G_EXC_ERROR;

672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');
673: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN others THEN
678: FND_FILE.put_line(fnd_file.log,'update_validated_address: Aborting processing inboundxml for this batch');
679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);

Line 683: RAISE FND_API.G_EXC_ERROR;

679: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
680: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
681: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
682: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
683: RAISE FND_API.G_EXC_ERROR;
684: end;
685:
686: -----------------------------------------------------------------------
687: -- Folowing Rule Function will be called from event subscription,

Line 719: WHEN FND_API.G_EXC_ERROR THEN

715: commit;
716: END IF;
717: RETURN 'SUCCESS';
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting processing inboundxml for this batch');
721: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
722: WF_EVENT.setErrorInfo(p_event, 'ERROR');
723: --return 'ERROR';

Line 724: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263

720: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting processing inboundxml for this batch');
721: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
722: WF_EVENT.setErrorInfo(p_event, 'ERROR');
723: --return 'ERROR';
724: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
725:
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
727: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting processing inboundxml for this batch');
728: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);

Line 726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

722: WF_EVENT.setErrorInfo(p_event, 'ERROR');
723: --return 'ERROR';
724: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
725:
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
727: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting processing inboundxml for this batch');
728: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
729: WF_EVENT.setErrorInfo(p_event, 'ERROR');
730: --return 'ERROR';

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263

727: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting processing inboundxml for this batch');
728: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
729: WF_EVENT.setErrorInfo(p_event, 'ERROR');
730: --return 'ERROR';
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
732: WHEN OTHERS THEN
733: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting processing inboundxml for this batch');
734: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
735: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);

Line 811: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

807: x_msg_count => l_msg_count,
808: x_msg_data => l_msg_data );
809:
810:
811: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
812: RAISE FND_API.G_EXC_ERROR;
813: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;

Line 812: RAISE FND_API.G_EXC_ERROR;

808: x_msg_data => l_msg_data );
809:
810:
811: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
812: RAISE FND_API.G_EXC_ERROR;
813: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:

Line 813: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

809:
810:
811: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
812: RAISE FND_API.G_EXC_ERROR;
813: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:
817: wf_event.AddParameterToList(

Line 814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

810:
811: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
812: RAISE FND_API.G_EXC_ERROR;
813: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:
817: wf_event.AddParameterToList(
818: p_name => 'ECX_MAP_CODE',

Line 839: WHEN FND_API.G_EXC_ERROR THEN

835: l_parameter_list.DELETE;
836:
837: RETURN 'SUCCESS';
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting outboundxml process for this batch');
841: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
842: WF_EVENT.setErrorInfo(p_event, 'ERROR');
843: --return 'ERROR';

Line 844: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263

840: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting outboundxml process for this batch');
841: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
842: WF_EVENT.setErrorInfo(p_event, 'ERROR');
843: --return 'ERROR';
844: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting outboundxml process for this batch');
848: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);

Line 846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

842: WF_EVENT.setErrorInfo(p_event, 'ERROR');
843: --return 'ERROR';
844: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting outboundxml process for this batch');
848: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
849: WF_EVENT.setErrorInfo(p_event, 'ERROR');
850: --return 'ERROR';

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263

847: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting outboundxml process for this batch');
848: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
849: WF_EVENT.setErrorInfo(p_event, 'ERROR');
850: --return 'ERROR';
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
852: WHEN OTHERS THEN
853: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting outboundxml process for this batch');
854: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
855: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);