751: x_msg_data => l_msg_data,
752: x_loc_id => l_loc_id,
753: x_org_id => l_org_id );
754: IF l_org_id IS NOT NULL THEN
755: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ASSIGN_ERROR');
756: FND_MESSAGE.SET_TOKEN('LOCATION_ID', l_location_id(i));
757: FND_MESSAGE.SET_TOKEN('SITE_OSR', l_site_orig_system_reference(i));
758: FND_MESSAGE.SET_TOKEN('ORG_ID',l_org_id );
759: msg := FND_MESSAGE.GET;
752: x_loc_id => l_loc_id,
753: x_org_id => l_org_id );
754: IF l_org_id IS NOT NULL THEN
755: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ASSIGN_ERROR');
756: FND_MESSAGE.SET_TOKEN('LOCATION_ID', l_location_id(i));
757: FND_MESSAGE.SET_TOKEN('SITE_OSR', l_site_orig_system_reference(i));
758: FND_MESSAGE.SET_TOKEN('ORG_ID',l_org_id );
759: msg := FND_MESSAGE.GET;
760: fnd_file.put_line(' ' || fnd_file.log,msg);
753: x_org_id => l_org_id );
754: IF l_org_id IS NOT NULL THEN
755: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ASSIGN_ERROR');
756: FND_MESSAGE.SET_TOKEN('LOCATION_ID', l_location_id(i));
757: FND_MESSAGE.SET_TOKEN('SITE_OSR', l_site_orig_system_reference(i));
758: FND_MESSAGE.SET_TOKEN('ORG_ID',l_org_id );
759: msg := FND_MESSAGE.GET;
760: fnd_file.put_line(' ' || fnd_file.log,msg);
761: END IF;
754: IF l_org_id IS NOT NULL THEN
755: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ASSIGN_ERROR');
756: FND_MESSAGE.SET_TOKEN('LOCATION_ID', l_location_id(i));
757: FND_MESSAGE.SET_TOKEN('SITE_OSR', l_site_orig_system_reference(i));
758: FND_MESSAGE.SET_TOKEN('ORG_ID',l_org_id );
759: msg := FND_MESSAGE.GET;
760: fnd_file.put_line(' ' || fnd_file.log,msg);
761: END IF;
762: EXCEPTION
755: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ASSIGN_ERROR');
756: FND_MESSAGE.SET_TOKEN('LOCATION_ID', l_location_id(i));
757: FND_MESSAGE.SET_TOKEN('SITE_OSR', l_site_orig_system_reference(i));
758: FND_MESSAGE.SET_TOKEN('ORG_ID',l_org_id );
759: msg := FND_MESSAGE.GET;
760: fnd_file.put_line(' ' || fnd_file.log,msg);
761: END IF;
762: EXCEPTION
763: WHEN OTHERS THEN
1477:
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: ROLLBACK;
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1482: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1483:
1484: errbuf := FND_MESSAGE.get;
1485: retcode := 2;
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: ROLLBACK;
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1482: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1483:
1484: errbuf := FND_MESSAGE.get;
1485: retcode := 2;
1486:
1480: ROLLBACK;
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1482: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1483:
1484: errbuf := FND_MESSAGE.get;
1485: retcode := 2;
1486:
1487: UPDATE hz_imp_batch_summary
1488: SET import_status = 'ERROR'